Scribd
Upload
360 views1 page

Working FF

This document contains default values and aliases for variables used in a formula to calculate employee allowance. It sets default date ranges for proration periods, start and end dates. It also defines aliases for override amount fields and default values for pay period and assignment dates. The formula retrieves an employee's available work units over a pay period to calculate their allowance amount.

Uploaded by

Dhina Karan
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
360 views1 page

Working FF

This document contains default values and aliases for variables used in a formula to calculate employee allowance. It sets default date ranges for proration periods, start and end dates. It also defines aliases for override amount fields and default values for pay period and assignment dates. The formula retrieves an employee's available work units over a pay period to calculate their allowance amount.

Uploaded by

Dhina Karan
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/ 1

/* Fast Formula for allowance*/

/*===================Default Proration dates===========*/


DEFAULT FOR Prorate_Start IS '1900/01/01 00:00:00' (Date)
DEFAULT FOR Prorate_End IS '4712/12/31 00:00:00' (Date)
DEFAULT FOR l_start_date IS '1900/01/01 00:00:00' (Date)
DEFAULT FOR l_end_date IS '4712/12/31 00:00:00' (Date)
DEFAULT FOR Amount is 0

/*===================Alias===================*/
ALIAS BASIC_OVERRIDE_AMOUNT_ASG_ENTRY_VALUE AS Basic_Override
ALIAS HOUSING_OVERRIDE_AMOUNT_ASG_ENTRY_VALUE AS Housing_Override
ALIAS TRANSPORT_OVERRIDE_AMOUNT_ASG_ENTRY_VALUE AS Transport_Override
ALIAS COMPANY_CAR_AVAILED_CAR_FACILITY_AVAILED_ASG_ENTRY_VALUE AS
Car_FACILITY_AVAILED

/*======Default Local Database Items Begins=======*/


DEFAULT FOR PAY_EARN_PERIOD_START IS '1900/01/01 00:00:00' (Date)
DEFAULT FOR PAY_EARN_PERIOD_END IS '4712/12/31 00:00:00' (Date)
DEFAULT FOR PAY_ASG_HIRE_DATE IS '1900/01/01 00:00:00' (Date)
DEFAULT FOR PAY_ASG_TERMINATION_DATE IS '4712/12/31 00:00:00' (DATE)
DEFAULT FOR ASG_HR_ASG_ID is 0
DEFAULT FOR TERM_HR_TERM_ID is 0

l_default_hours_per_day = 0
l_asg_hr_asg_id = ASG_HR_ASG_ID

SET_INPUT('actual_start_date', PAY_EARN_PERIOD_START )
SET_INPUT('actual_end_date', PAY_EARN_PERIOD_END)
SET_INPUT('unit_type', 'D')
SET_INPUT('hr_assign_id', l_asg_hr_asg_id)
SET_INPUT('entry_level', 'ENTRY_LEVEL ')
EXECUTE('GET_PAY_AVAILABILITY')
l_duration_inc_hol = GET_OUTPUT('l_units',0)

mesg = 'l_duration_inc_hol : '+to_char(l_duration_inc_hol) + ' l_duration_exc_hol :


'+to_char(l_duration_exc_hol)

RETURN mesg

You might also like