Scribd
Upload
13 views2 pages

Housing FF

The document outlines a formula for calculating a Housing Allowance in Oracle Payroll, which is set at 25% of the Basic Salary. It includes default values for various parameters and specifies input statements for the calculation. The formula also accounts for termination dates to ensure accurate end date calculations.

Uploaded by

oracleuser2520
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
13 views2 pages

Housing FF

The document outlines a formula for calculating a Housing Allowance in Oracle Payroll, which is set at 25% of the Basic Salary. It includes default values for various parameters and specifies input statements for the calculation. The formula also accounts for termination dates to ensure accurate end date calculations.

Uploaded by

oracleuser2520
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 2

/*Housing Allowance Salary Formulae

FORMULA NAME: Housing Allowance

FORMULA TYPE: Oracle Payroll

DESCRIPTION:

Housing Allowance Formulae

Formula Results : It is going to fetch 25% of Basic as Housing Allowance

consultant name : Kumar

*******************************************************************************/

/* Database Item Defaults */

DEFAULT FOR amount is 0


DEFAULT FOR PAY_EARN_PERIOD_START is '0001/01/01 00:00:00' (date)
DEFAULT FOR PAY_EARN_PERIOD_END is '4712/12/31 00:00:00' (date)
DEFAULT FOR PAY_ASG_TERMINATION_DATE is '0001/01/01 00:00:00' (date)
DEFAULT FOR pay_value is 0
Default for BASIC_SALARY_AMOUNT_ASG_ENTRY_VALUE is 0
Default for days_in_month is 0

/* Inputs statemnets */

INPUTS ARE amount (number),

pay_value(number)

l_amount = amount
l_value = 0
days_in_month = TO_NUMBER(TO_CHAR(last_day(PAY_EARN_PERIOD_END), 'DD'))

/***** Initialize Local Variables *****/

l_actual_start_date = PAY_EARN_PERIOD_START
l_actual_end_date = '4712/12/31 00:00:00' (date)

/****** end of local Variables*****/

if PAY_ASG_TERMINATION_DATE WAS NOT DEFAULTED then


(
l_actual_end_date=least(PAY_EARN_PERIOD_END,PAY_ASG_TERMINATION_DATE)

)
else
(
l_actual_end_date=PAY_EARN_PERIOD_END

l_Value = (NOV_BASIC_SALARY_AMOUNT_ASG_ENTRY_VALUE/12*0.25)

)
/****************RETURN SECTION************/

Return l_Value

You might also like