View: PAY_HK_ASG_LEAVE_BALANCES_V

Product:	PAY - Payroll
Description:	Hong Kong localisation view.
Implementation/DBA Data:	APPS.PAY_HK_ASG_LEAVE_BALANCES_V

View Text

SELECT PAA.ASSIGNMENT_ID ASSIGNMENT_ID
, PAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, PAP.ACCRUAL_PLAN_ID ACCRUAL_PLAN_ID
, PTP.END_DATE END_DATE
, PPA.PAYROLL_ID PAYROLL_ID
, PAP.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, HL.MEANING ACCRUAL_UNITS_OF_MEASURE
FROM PAY_ACCRUAL_PLANS PAP
, PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_LINKS_F PEL
, PAY_ELEMENT_ENTRIES_F PEE
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
, PER_TIME_PERIODS PTP
, HR_LOOKUPS HL
WHERE PET.ELEMENT_TYPE_ID = PAP.ACCRUAL_PLAN_ELEMENT_TYPE_ID
AND PEL.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PEE.ELEMENT_LINK_ID = PEL.ELEMENT_LINK_ID
AND PAA.ASSIGNMENT_ID = PEE.ASSIGNMENT_ID
AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PTP.PAYROLL_ID = PPA.PAYROLL_ID
AND PAP.ACCRUAL_UNITS_OF_MEASURE = HL.LOOKUP_CODE
AND HL.LOOKUP_TYPE = 'HOURS_OR_DAYS'
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