Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAY_GB_YEAR_END_PAYROLLS_V |
SELECT PACT.PAYROLL_ACTION_ID
, PACT.ACTION_STATUS
, PACT.BUSINESS_GROUP_ID
, PACT.REQUEST_ID
, PACT.REPORT_CATEGORY
, PACT.START_DATE
, PACT.EFFECTIVE_DATE
, TO_NUMBER(TO_CHAR(PACT.START_DATE
, 'YYYY') ) + 1
, PAY_GB_EOY_ARCHIVE.CANONICAL_TO_NUMBER(AIC.CONTEXT)
, PAY_GB_EOY_ARCHIVE.GET_ARCH_STR(FAI.CONTEXT1
, 'X_ECON'
, AIC.CONTEXT)
, PAY_GB_EOY_ARCHIVE.GET_ARCH_STR( FAI.CONTEXT1
, 'X_EMPLOYERS_ADDRESS_LINE'
, AIC.CONTEXT)
, PAY_GB_EOY_ARCHIVE.GET_ARCH_STR( FAI.CONTEXT1
, 'X_EMPLOYERS_NAME'
, AIC.CONTEXT)
, PAY_GB_EOY_ARCHIVE.GET_ARCH_DATE( FAI.CONTEXT1
, 'X_END_PREVIOUS_YEAR'
, AIC.CONTEXT)
, PAY_GB_EOY_ARCHIVE.GET_ARCH_DATE( FAI.CONTEXT1
, 'X_END_YEAR'
, AIC.CONTEXT)
, PAY_GB_EOY_ARCHIVE.GET_ARCH_NUM( FAI.CONTEXT1
, 'X_MAX_PERIOD_NUMBER'
, AIC.CONTEXT)
, PAY_GB_EOY_ARCHIVE.GET_ARCH_STR( FAI.CONTEXT1
, 'X_PAYROLL_NAME'
, AIC.CONTEXT)
, PAY_GB_EOY_ARCHIVE.GET_ARCH_STR( FAI.CONTEXT1
, 'X_PERIOD_TYPE'
, AIC.CONTEXT)
, FAI.VALUE
, PAY_GB_EOY_ARCHIVE.GET_ARCH_NUM( FAI.CONTEXT1
, 'X_SMP_COMPENSATION'
, AIC.CONTEXT)
, PAY_GB_EOY_ARCHIVE.GET_ARCH_NUM( FAI.CONTEXT1
, 'X_SMP_RECOVERED'
, AIC.CONTEXT)
, PAY_GB_EOY_ARCHIVE.GET_ARCH_NUM( FAI.CONTEXT1
, 'X_SAP_COMPENSATION'
, AIC.CONTEXT)
, PAY_GB_EOY_ARCHIVE.GET_ARCH_NUM( FAI.CONTEXT1
, 'X_SAP_RECOVERED'
, AIC.CONTEXT)
, PAY_GB_EOY_ARCHIVE.GET_ARCH_NUM( FAI.CONTEXT1
, 'X_SPP_COMPENSATION'
, AIC.CONTEXT)
, PAY_GB_EOY_ARCHIVE.GET_ARCH_NUM( FAI.CONTEXT1
, 'X_SPP_RECOVERED'
, AIC.CONTEXT)
, PAY_GB_EOY_ARCHIVE.GET_ARCH_NUM( FAI.CONTEXT1
, 'X_SSP_RECOVERED'
, AIC.CONTEXT)
, PAY_GB_EOY_ARCHIVE.GET_ARCH_DATE( FAI.CONTEXT1
, 'X_START_PREVIOUS_YEAR'
, AIC.CONTEXT)
, PAY_GB_EOY_ARCHIVE.GET_ARCH_DATE( FAI.CONTEXT1
, 'X_START_YEAR'
, AIC.CONTEXT)
, PAY_GB_EOY_ARCHIVE.GET_ARCH_STR( FAI.CONTEXT1
, 'X_TAX_DISTRICT_NAME'
, AIC.CONTEXT)
, PAY_GB_EOY_ARCHIVE.GET_ARCH_NUM( FAI.CONTEXT1
, 'X_TAX_DISTRICT_REFERENCE'
, AIC.CONTEXT)
, PAY_GB_EOY_ARCHIVE.GET_ARCH_STR( FAI.CONTEXT1
, 'X_TAX_REFERENCE_NUMBER'
, AIC.CONTEXT)
FROM FF_ARCHIVE_ITEM_CONTEXTS AIC
, FF_ARCHIVE_ITEMS FAI
, FF_USER_ENTITIES FUE
, PAY_PAYROLL_ACTIONS PACT
WHERE PACT.REPORT_TYPE = 'EOY'
AND PACT.REPORT_QUALIFIER = 'GB'
AND PACT.ACTION_TYPE = 'X'
AND PACT.PAYROLL_ACTION_ID = FAI.CONTEXT1
AND FUE.USER_ENTITY_NAME = 'X_PERMIT_NUMBER'
AND FUE.LEGISLATION_CODE = 'GB'
AND FUE.BUSINESS_GROUP_ID IS NULL
AND FUE.USER_ENTITY_ID = FAI.USER_ENTITY_ID
AND AIC.ARCHIVE_ITEM_ID = FAI.ARCHIVE_ITEM_ID
AND AIC.SEQUENCE_NO = 1