View: PAY_AU_LEAVE_LIABILITY_V

Product:	PAY - Payroll
Description:	Australian localisation view.
Implementation/DBA Data:	APPS.PAY_AU_LEAVE_LIABILITY_V

View Text

SELECT AA.PAYROLL_ACTION_ID PAYROLL_ACTION_ID
, AA.ASSIGNMENT_ID ASSIGNMENT_ID
, AA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, AP.ACCRUAL_CATEGORY ACCRUAL_CATEGORY
, TO_NUMBER(LACC.AICAAPCONTEXT) ACCRUAL_PLAN_ID
, TO_NUMBER(LENT.AIEVALUE) LEAVE_ENTITLEMENT
, TO_NUMBER(LENTV.AIEVVALUE) ENTITLEMENT_VALUE
, TO_NUMBER(LACC.AIAVALUE) LEAVE_ACCRUAL
, TO_NUMBER(LACCV.AIAVVALUE) ACCRUAL_VALUE
FROM (SELECT AI_A.CONTEXT1 AIACONTEXT1
, AIC_A_AS.CONTEXT AICAASCONTEXT
, AIC_A_AP.CONTEXT AICAAPCONTEXT
, AI_A.VALUE AIAVALUE
FROM FF_USER_ENTITIES UE_A
, FF_ARCHIVE_ITEMS AI_A
, FF_ARCHIVE_ITEM_CONTEXTS AIC_A_AS
, FF_CONTEXTS C_A_AS
, FF_ARCHIVE_ITEM_CONTEXTS AIC_A_AP
, FF_CONTEXTS C_A_AP
WHERE UE_A.USER_ENTITY_NAME = 'X_LEAVE_ACCRUAL' AND AI_A.USER_ENTITY_ID = UE_A.USER_ENTITY_ID AND AIC_A_AS.ARCHIVE_ITEM_ID = AI_A.ARCHIVE_ITEM_ID AND C_A_AS.CONTEXT_NAME = 'ASSIGNMENT_ACTION_ID' AND AIC_A_AS.CONTEXT_ID = C_A_AS.CONTEXT_ID AND AIC_A_AP.ARCHIVE_ITEM_ID = AI_A.ARCHIVE_ITEM_ID AND C_A_AP.CONTEXT_NAME = 'ACCRUAL_PLAN_ID' AND AIC_A_AP.CONTEXT_ID = C_A_AP.CONTEXT_ID ) LACC
, (SELECT AIC_E_AS.CONTEXT AICEASCONTEXT
, AI_E.CONTEXT1 AIECONTEXT1
, AIC_E_AP.CONTEXT AICEAPCONTEXT
, AI_E.VALUE AIEVALUE
FROM FF_USER_ENTITIES UE_E
, FF_ARCHIVE_ITEMS AI_E
, FF_ARCHIVE_ITEM_CONTEXTS AIC_E_AS
, FF_CONTEXTS C_E_AS
, FF_ARCHIVE_ITEM_CONTEXTS AIC_E_AP
, FF_CONTEXTS C_E_AP WHERE UE_E.USER_ENTITY_NAME = 'X_LEAVE_ENTITLEMENT' AND AI_E.USER_ENTITY_ID = UE_E.USER_ENTITY_ID AND AIC_E_AS.ARCHIVE_ITEM_ID = AI_E.ARCHIVE_ITEM_ID AND C_E_AS.CONTEXT_NAME = 'ASSIGNMENT_ACTION_ID' AND AIC_E_AS.CONTEXT_ID = C_E_AS.CONTEXT_ID AND AIC_E_AP.ARCHIVE_ITEM_ID = AI_E.ARCHIVE_ITEM_ID AND C_E_AP.CONTEXT_NAME = 'ACCRUAL_PLAN_ID' AND AIC_E_AP.CONTEXT_ID = C_E_AP.CONTEXT_ID )LENT
, (SELECT AIC_AV_AS.CONTEXT AICAVASCONTEXT
, AI_AV.CONTEXT1 AIAVCONTEXT1
, AIC_AV_AP.CONTEXT AICAVAPCONTEXT
, AI_AV.VALUE AIAVVALUE FROM FF_USER_ENTITIES UE_AV
, FF_ARCHIVE_ITEMS AI_AV
, FF_ARCHIVE_ITEM_CONTEXTS AIC_AV_AS
, FF_CONTEXTS C_AV_AS
, FF_ARCHIVE_ITEM_CONTEXTS AIC_AV_AP
, FF_CONTEXTS C_AV_AP WHERE UE_AV.USER_ENTITY_NAME = 'X_ACCRUAL_VALUE' AND AI_AV.USER_ENTITY_ID = UE_AV.USER_ENTITY_ID AND AIC_AV_AS.ARCHIVE_ITEM_ID = AI_AV.ARCHIVE_ITEM_ID AND C_AV_AS.CONTEXT_NAME = 'ASSIGNMENT_ACTION_ID' AND AIC_AV_AS.CONTEXT_ID = C_AV_AS.CONTEXT_ID AND AIC_AV_AP.ARCHIVE_ITEM_ID = AI_AV.ARCHIVE_ITEM_ID AND C_AV_AP.CONTEXT_NAME = 'ACCRUAL_PLAN_ID' AND AIC_AV_AP.CONTEXT_ID = C_AV_AP.CONTEXT_ID )LACCV
, (SELECT AI_EV.CONTEXT1 AIEVCONTEXT1
, AIC_EV_AS.CONTEXT AICEVASCONTEXT
, AIC_EV_AP.CONTEXT AICEVAPCONTEXT
, AI_EV.VALUE AIEVVALUE FROM FF_USER_ENTITIES UE_EV
, FF_ARCHIVE_ITEMS AI_EV
, FF_ARCHIVE_ITEM_CONTEXTS AIC_EV_AS
, FF_CONTEXTS C_EV_AS
, FF_ARCHIVE_ITEM_CONTEXTS AIC_EV_AP
, FF_CONTEXTS C_EV_AP WHERE UE_EV.USER_ENTITY_NAME = 'X_ENTITLEMENT_VALUE' AND AI_EV.USER_ENTITY_ID = UE_EV.USER_ENTITY_ID AND AIC_EV_AS.ARCHIVE_ITEM_ID = AI_EV.ARCHIVE_ITEM_ID AND C_EV_AS.CONTEXT_NAME = 'ASSIGNMENT_ACTION_ID' AND AIC_EV_AS.CONTEXT_ID = C_EV_AS.CONTEXT_ID AND AIC_EV_AP.ARCHIVE_ITEM_ID = AI_EV.ARCHIVE_ITEM_ID AND C_EV_AP.CONTEXT_NAME = 'ACCRUAL_PLAN_ID' AND AIC_EV_AP.CONTEXT_ID = C_EV_AP.CONTEXT_ID )LENTV
, PAY_ACCRUAL_PLANS AP
, PAY_ASSIGNMENT_ACTIONS AA
WHERE LACC.AIACONTEXT1 = AA.ASSIGNMENT_ACTION_ID
AND AA.ASSIGNMENT_ACTION_ID = AICAASCONTEXT
AND AP.ACCRUAL_PLAN_ID = LACC.AICAAPCONTEXT
AND LENT.AICEASCONTEXT = AA.ASSIGNMENT_ACTION_ID
AND LENT.AIECONTEXT1 = AA.ASSIGNMENT_ACTION_ID
AND LENT.AICEAPCONTEXT = AP.ACCRUAL_PLAN_ID
AND LACCV.AICAVASCONTEXT = AA.ASSIGNMENT_ACTION_ID
AND LACCV.AIAVCONTEXT1 = AA.ASSIGNMENT_ACTION_ID
AND LACCV.AICAVAPCONTEXT = AP.ACCRUAL_PLAN_ID
AND LENTV.AIEVCONTEXT1 = AA.ASSIGNMENT_ACTION_ID
AND LENTV.AICEVASCONTEXT = AA.ASSIGNMENT_ACTION_ID
AND LENTV.AICEVAPCONTEXT = AP.ACCRUAL_PLAN_ID

Columns