View: PAY_SG_LEAVE_BALANCES_V

Product:	PAY - Payroll
Description:	Singapore localisation view.
Implementation/DBA Data:	APPS.PAY_SG_LEAVE_BALANCES_V

View Text

SELECT PAC.ASSIGNMENT_ID
, PAC.ASSIGNMENT_ACTION_ID
, PPL.ACCRUAL_PLAN_ID
, PPA.EFFECTIVE_DATE
, PPA.PAYROLL_ID
, PPL.BUSINESS_GROUP_ID
FROM PER_ABSENCE_ATTENDANCE_TYPES PAT
, PAY_ACCRUAL_PLANS PPL
, PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_LINKS_F PEL
, PAY_ELEMENT_ENTRIES_F PEE
, PAY_ASSIGNMENT_ACTIONS PAC
, PAY_PAYROLL_ACTIONS PPA
, PER_TIME_PERIODS PTP
WHERE PPL.PTO_INPUT_VALUE_ID = PAT.INPUT_VALUE_ID
AND PET.ELEMENT_TYPE_ID = PPL.ACCRUAL_PLAN_ELEMENT_TYPE_ID
AND PEL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PEE.ELEMENT_LINK_ID = PEL.ELEMENT_LINK_ID
AND PAC.ASSIGNMENT_ID = PEE.ASSIGNMENT_ID
AND PPA.PAYROLL_ACTION_ID = PAC.PAYROLL_ACTION_ID
AND PTP.PAYROLL_ID = PPA.PAYROLL_ID
AND PPA.DATE_EARNED BETWEEN PTP.START_DATE
AND PTP.END_DATE
AND PPA.DATE_EARNED BETWEEN PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE

Columns