View: PAY_GB_YEAR_END_VALUES_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_GB_YEAR_END_VALUES_V

View Text

SELECT ACT.ASSIGNMENT_ACTION_ID
, ACT.ASSIGNMENT_ID
, ACT.PAYROLL_ACTION_ID
, PAY_GB_EOY_ARCHIVE.CANONICAL_TO_DATE(FAI1.VALUE) EFFECTIVE_END_DATE
, DECODE(AIC1.CONTEXT
, '1'
, 'Y'
, '0'
, 'N'
, '2'
, 'M') REPORTABLE
, AIC2.CONTEXT NI_CATEGORY_CODE
, AIC3.CONTEXT SCON
, PAY_GB_EOY_ARCHIVE.GET_ARCH_NUM(FAI1.CONTEXT1
, 'X_NI_'|| DECODE(AIC3.CONTEXT
, NULL
, NULL
, 'SCON_')|| 'ABLE_ET'
, AIC1.CONTEXT
, AIC2.CONTEXT
, AIC3.CONTEXT) NI_ABLE_ET
, PAY_GB_EOY_ARCHIVE.GET_ARCH_NUM(FAI1.CONTEXT1
, 'X_NI_'|| DECODE(AIC3.CONTEXT
, NULL
, NULL
, 'SCON_')|| 'ABLE_EET'
, AIC1.CONTEXT
, AIC2.CONTEXT
, AIC3.CONTEXT) NI_ABLE_EET
, PAY_GB_EOY_ARCHIVE.GET_ARCH_NUM(FAI1.CONTEXT1
, 'X_NI_'|| DECODE(AIC3.CONTEXT
, NULL
, NULL
, 'SCON_')|| 'ABLE_LEL'
, AIC1.CONTEXT
, AIC2.CONTEXT
, AIC3.CONTEXT) NI_ABLE_LEL
, PAY_GB_EOY_ARCHIVE.GET_ARCH_NUM(FAI1.CONTEXT1
, 'X_NI_'|| DECODE(AIC3.CONTEXT
, NULL
, NULL
, 'SCON_')|| 'ABLE_UEL'
, AIC1.CONTEXT
, AIC2.CONTEXT
, AIC3.CONTEXT) NI_ABLE_UEL
, PAY_GB_EOY_ARCHIVE.GET_ARCH_NUM(FAI1.CONTEXT1
, 'X_NI_'|| DECODE(AIC3.CONTEXT
, NULL
, NULL
, 'SCON_')|| 'EARNINGS'
, AIC1.CONTEXT
, AIC2.CONTEXT
, AIC3.CONTEXT) EARNINGS
, PAY_GB_EOY_ARCHIVE.GET_ARCH_NUM(FAI1.CONTEXT1
, 'X_NI_'|| DECODE(AIC3.CONTEXT
, NULL
, NULL
, 'SCON_')|| 'EMPLOYEES_CONTRIBUTIONS'
, AIC1.CONTEXT
, AIC2.CONTEXT
, AIC3.CONTEXT) EMPLOYEES_CONTRIBUTIONS
, PAY_GB_EOY_ARCHIVE.GET_ARCH_NUM(FAI1.CONTEXT1
, 'X_NI_'|| DECODE(AIC3.CONTEXT
, NULL
, NULL
, 'SCON_')|| 'EMPLOYERS_REBATE'
, AIC1.CONTEXT
, AIC2.CONTEXT
, AIC3.CONTEXT) EMPLOYERS_REBATE
, PAY_GB_EOY_ARCHIVE.GET_ARCH_NUM(FAI1.CONTEXT1
, 'X_NI_'|| DECODE(AIC3.CONTEXT
, NULL
, NULL
, 'SCON_')||'EMPLOYEES_REBATE'
, AIC1.CONTEXT
, AIC2.CONTEXT
, AIC3.CONTEXT) EMPLOYEES_REBATE
, PAY_GB_EOY_ARCHIVE.GET_ARCH_STR(FAI1.CONTEXT1
, 'X_NI_'|| DECODE(AIC3.CONTEXT
, NULL
, NULL
, 'SCON_')|| 'REFUND'
, AIC1.CONTEXT
, AIC2.CONTEXT
, AIC3.CONTEXT) NI_REFUND
, PAY_GB_EOY_ARCHIVE.CANONICAL_TO_NUMBER(FAI2.VALUE) TOTAL_CONTRIBUTIONS
, PAY_GB_EOY_ARCHIVE.GET_ARCH_NUM(FAI1.CONTEXT1
, 'X_NI_'|| DECODE(AIC3.CONTEXT
, NULL
, NULL
, 'SCON_')|| 'ABLE_AUEL'
, AIC1.CONTEXT
, AIC2.CONTEXT
, AIC3.CONTEXT) NI_ABLE_AUEL
FROM FF_ARCHIVE_ITEM_CONTEXTS AIC3
, FF_ARCHIVE_ITEM_CONTEXTS AIC2
, FF_ARCHIVE_ITEM_CONTEXTS AIC1
, FF_ARCHIVE_ITEMS FAI2
, FF_USER_ENTITIES FUE2
, FF_ARCHIVE_ITEMS FAI1
, FF_USER_ENTITIES FUE1
, PAY_ASSIGNMENT_ACTIONS ACT
WHERE ACT.ASSIGNMENT_ACTION_ID = FAI1.CONTEXT1
AND ACT.ASSIGNMENT_ACTION_ID = FAI2.CONTEXT1
AND FUE1.USER_ENTITY_NAME = 'X_EFFECTIVE_END_DATE'
AND FUE2.USER_ENTITY_NAME LIKE 'X_NI_%TOTAL_CONTRIBUTIONS'
AND FUE1.LEGISLATION_CODE = 'GB'
AND FUE1.BUSINESS_GROUP_ID IS NULL
AND FUE2.LEGISLATION_CODE = 'GB'
AND FUE2.BUSINESS_GROUP_ID IS NULL
AND FUE1.USER_ENTITY_ID = FAI1.USER_ENTITY_ID + 0
AND FUE2.USER_ENTITY_ID = FAI2.USER_ENTITY_ID + 0
AND AIC1.ARCHIVE_ITEM_ID = FAI2.ARCHIVE_ITEM_ID
AND AIC2.ARCHIVE_ITEM_ID = FAI2.ARCHIVE_ITEM_ID
AND AIC3.ARCHIVE_ITEM_ID (+) = FAI2.ARCHIVE_ITEM_ID
AND AIC1.SEQUENCE_NO = 1
AND AIC2.SEQUENCE_NO = 2
AND AIC3.SEQUENCE_NO (+) = 3

Columns