Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAY_CA_EOY_T4A_REG_V |
SELECT PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_SIN') CAEOY_EMPLOYEE_SIN
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_NUMBER') CAEOY_EMPLOYEE_NUMBER
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_LAST_NAME') CAEOY_EMPLOYEE_LAST_NAME
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_FIRST_NAME') CAEOY_EMPLOYEE_FIRST_NAME
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_INITIAL') CAEOY_EMPLOYEE_INITIAL
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_ADDRESS_LINE1') CAEOY_EMPLOYEE_ADDRESS_LINE1
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_ADDRESS_LINE2') CAEOY_EMPLOYEE_ADDRESS_LINE2
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_ADDRESS_LINE3') CAEOY_EMPLOYEE_ADDRESS_LINE3
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_CITY') CAEOY_EMPLOYEE_CITY
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_PROVINCE') CAEOY_EMPLOYEE_PROVINCE
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_COUNTRY') CAEOY_EMPLOYEE_COUNTRY
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_EMPLOYEE_POSTAL_CODE') CAEOY_EMPLOYEE_POSTAL_CODE
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_T4_ORGANIZATION_ID') CAEOY_T4A_ORGANIZATION_ID
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_T4_LOCATION_ID') CAEOY_T4A_LOCATION_ID
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_PERSON_ID') CAEOY_PERSON_ID
, PPA.BUSINESS_GROUP_ID
, PAA.TAX_UNIT_ID
, PPA.PAYROLL_ACTION_ID
, FAI.CONTEXT1
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_T4A_BOX16_PER_GRE_YTD') T4A_BOX16
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_T4A_BOX18_PER_GRE_YTD') T4A_BOX18
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_T4A_BOX20_PER_GRE_YTD') T4A_BOX20
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_FED_WITHHELD_PER_GRE_YTD') T4A_BOX22
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_T4A_BOX24_PER_GRE_YTD') T4A_BOX24
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_T4A_BOX26_PER_GRE_YTD') T4A_BOX26
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_T4A_BOX27_PER_GRE_YTD') T4A_BOX27
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_T4A_BOX28_PER_GRE_YTD') T4A_BOX28
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_T4A_BOX30_PER_GRE_YTD') T4A_BOX30
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_T4A_BOX32_PER_GRE_YTD') T4A_BOX32
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_T4A_BOX34_PER_GRE_YTD') T4A_BOX34
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_T4A_EMPLOYEE_REGISTRATION_NO') T4A_BOX36
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_T4A_FOOTNOTE_CODE') T4A_BOX38
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_T4A_BOX40_PER_GRE_YTD') T4A_BOX40
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_T4A_BOX42_PER_GRE_YTD') T4A_BOX42
, PAY_CA_ARCHIVE_UTILS.GET_ARCHIVE_VALUE(FAI.CONTEXT1
, 'CAEOY_T4A_BOX46_PER_GRE_YTD') T4A_BOX46
FROM FF_ARCHIVE_ITEMS FAI
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
WHERE PPA.PAYROLL_ACTION_ID=PAA.PAYROLL_ACTION_ID
AND PPA.ACTION_TYPE='X'
AND PPA.REPORT_TYPE='T4A'
AND PPA.ACTION_STATUS='C'
AND PAA.ASSIGNMENT_ACTION_ID=FAI.CONTEXT1 GROUP BY FAI.CONTEXT1
, PPA.PAYROLL_ACTION_ID
, PPA.BUSINESS_GROUP_ID
, PAA.TAX_UNIT_ID