View: PAY_NZ_ASG_LEAVE_BALANCES_V

Product:	PAY - Payroll
Description:	New Zealand localisation view.
Implementation/DBA Data:	APPS.PAY_NZ_ASG_LEAVE_BALANCES_V

View Text

SELECT AA.ASSIGNMENT_ID ASSIGNMENT_ID
, AA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, AP.ACCRUAL_PLAN_ID ACCRUAL_PLAN_ID
, TP.END_DATE EFFECTIVE_DATE
, PA.PAYROLL_ID PAYROLL_ID
, AP.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
FROM PAY_ACCRUAL_PLANS AP
, PAY_ELEMENT_TYPES_F ET
, PAY_ELEMENT_LINKS_F EL
, PAY_ELEMENT_ENTRIES_F EE
, PAY_ASSIGNMENT_ACTIONS AA
, PAY_PAYROLL_ACTIONS PA
, PER_TIME_PERIODS TP
WHERE ET.ELEMENT_TYPE_ID = AP.ACCRUAL_PLAN_ELEMENT_TYPE_ID
AND EL.ELEMENT_TYPE_ID = ET.ELEMENT_TYPE_ID
AND EE.ELEMENT_LINK_ID = EL.ELEMENT_LINK_ID
AND AA.ASSIGNMENT_ID = EE.ASSIGNMENT_ID
AND PA.PAYROLL_ACTION_ID = AA.PAYROLL_ACTION_ID
AND TP.PAYROLL_ID = PA.PAYROLL_ID
AND PA.DATE_EARNED BETWEEN TP.START_DATE
AND TP.END_DATE
AND PA.DATE_EARNED BETWEEN ET.EFFECTIVE_START_DATE
AND ET.EFFECTIVE_END_DATE
AND PA.DATE_EARNED BETWEEN EL.EFFECTIVE_START_DATE
AND EL.EFFECTIVE_END_DATE
AND PA.DATE_EARNED BETWEEN EE.EFFECTIVE_START_DATE
AND EE.EFFECTIVE_END_DATE

Columns