VIEW: APPS.PAY_CA_EOY_T4A_REG_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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