VIEW: APPS.PAY_HK_IR56_ARCHIVES_V

Source

View Text - Preformatted

SELECT paa.rowid ,paa.assignment_action_id ,paa.assignment_id ,ppa.payroll_action_id ,pay_core_utils.get_parameter('REPORTING_YEAR',ppa.legislative_parameters) ,pay_hk_ir56_report.get_archive_value('X_HK_ISSUE_DATE', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_SHEET_NO', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_EMPLOYEE_TFN', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_EMPLOYER_TFN', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_EMPLOYER_NAME', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_LAST_NAME', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_OTHER_NAMES', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_CHINESE_FULL_NAME', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_HKID', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_PASSPORT_INFO', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_SEX', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_MARITAL_STATUS', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_SPOUSE_NAME', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_SPOUSE_HKID', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_SPOUSE_PASSPORT_INFO', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_RESIDENTIAL_ADDRESS_1', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_RESIDENTIAL_ADDRESS_2', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_RES_COUNTRY', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_RESIDENTIAL_ADDRESS_AREA_CODE', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_CORRESPONDENCE_ADDRESS_1', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_CORRESPONDENCE_ADDRESS_2', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_CAPACITY_EMPLOYED', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_PRINCIPAL_EMPLOYER_NAME', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_EMPLOYMENT_START_DATE', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_EMPLOYMENT_END_DATE', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_A_DESCRIPTION', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_A_PERIOD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_A_ASG_LE_YTD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_B_DESCRIPTION', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_B_PERIOD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_B_ASG_LE_YTD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_C_DESCRIPTION', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_C_PERIOD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_C_ASG_LE_YTD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_D_DESCRIPTION', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_D_PERIOD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_D_ASG_LE_YTD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_E_DESCRIPTION', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_E_PERIOD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_E_ASG_LE_YTD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_F_DESCRIPTION', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_F_PERIOD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_F_ASG_LE_YTD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_G_DESCRIPTION', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_G_PERIOD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_G_ASG_LE_YTD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_H_DESCRIPTION', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_H_PERIOD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_H_ASG_LE_YTD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_I_DESCRIPTION', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_I_PERIOD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_I_ASG_LE_YTD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_J_DESCRIPTION', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_J_PERIOD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_J_ASG_LE_YTD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_K1_DESCRIPTION', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_K1_PERIOD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_K1_ASG_LE_YTD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_K2_DESCRIPTION', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_K2_PERIOD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_K2_ASG_LE_YTD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_K3_DESCRIPTION', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_K3_PERIOD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_K3_ASG_LE_YTD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_L_DESCRIPTION', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_L_PERIOD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_IR56_L_ASG_LE_YTD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_QUARTERS_PROVIDED', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_QUARTERS_1_ADDRESS', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_QUARTERS_1_NATURE', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_QUARTERS_1_PERIOD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_QUARTERS_1_ER_TO_LL_LE_YTD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_QUARTERS_1_EE_TO_LL_LE_YTD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_QUARTERS_1_REFUND_TO_EE_LE_YTD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_QUARTERS_1_EE_TO_ER_LE_YTD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_QUARTERS_2_ADDRESS', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_QUARTERS_2_NATURE', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_QUARTERS_2_PERIOD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_QUARTERS_2_ER_TO_LL_LE_YTD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_QUARTERS_2_EE_TO_LL_LE_YTD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_QUARTERS_2_REFUND_TO_EE_LE_YTD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_QUARTERS_2_EE_TO_ER_LE_YTD', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_OVERSEAS_CONCERN', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_OVERSEAS_NAME', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_OVERSEAS_ADDRESS', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_OVERSEAS_AMOUNT', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_REMARKS', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_DESIGNATION', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_CONTACT', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_ARCHIVE_MESSAGE', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_LAST_RUN_DATE', paa.assignment_action_id) ,pay_hk_ir56_report.get_archive_value('X_HK_LAST_RUN_TYPE', paa.assignment_action_id) from pay_payroll_actions ppa, pay_assignment_actions paa WHERE paa.payroll_action_id = ppa.payroll_action_id and ppa.action_type = 'X' and ppa.action_status = 'C' and paa.action_status = 'C' and ppa.report_type ='HK_IR56B_ARCHIVE'

View Text - HTML Formatted

SELECT PAA.ROWID
, PAA.ASSIGNMENT_ACTION_ID
, PAA.ASSIGNMENT_ID
, PPA.PAYROLL_ACTION_ID
, PAY_CORE_UTILS.GET_PARAMETER('REPORTING_YEAR'
, PPA.LEGISLATIVE_PARAMETERS)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_ISSUE_DATE'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_SHEET_NO'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_EMPLOYEE_TFN'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_EMPLOYER_TFN'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_EMPLOYER_NAME'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_LAST_NAME'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_OTHER_NAMES'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_CHINESE_FULL_NAME'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_HKID'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_PASSPORT_INFO'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_SEX'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_MARITAL_STATUS'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_SPOUSE_NAME'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_SPOUSE_HKID'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_SPOUSE_PASSPORT_INFO'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_RESIDENTIAL_ADDRESS_1'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_RESIDENTIAL_ADDRESS_2'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_RES_COUNTRY'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_RESIDENTIAL_ADDRESS_AREA_CODE'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_CORRESPONDENCE_ADDRESS_1'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_CORRESPONDENCE_ADDRESS_2'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_CAPACITY_EMPLOYED'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_PRINCIPAL_EMPLOYER_NAME'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_EMPLOYMENT_START_DATE'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_EMPLOYMENT_END_DATE'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_A_DESCRIPTION'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_A_PERIOD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_A_ASG_LE_YTD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_B_DESCRIPTION'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_B_PERIOD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_B_ASG_LE_YTD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_C_DESCRIPTION'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_C_PERIOD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_C_ASG_LE_YTD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_D_DESCRIPTION'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_D_PERIOD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_D_ASG_LE_YTD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_E_DESCRIPTION'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_E_PERIOD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_E_ASG_LE_YTD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_F_DESCRIPTION'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_F_PERIOD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_F_ASG_LE_YTD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_G_DESCRIPTION'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_G_PERIOD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_G_ASG_LE_YTD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_H_DESCRIPTION'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_H_PERIOD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_H_ASG_LE_YTD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_I_DESCRIPTION'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_I_PERIOD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_I_ASG_LE_YTD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_J_DESCRIPTION'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_J_PERIOD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_J_ASG_LE_YTD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_K1_DESCRIPTION'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_K1_PERIOD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_K1_ASG_LE_YTD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_K2_DESCRIPTION'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_K2_PERIOD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_K2_ASG_LE_YTD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_K3_DESCRIPTION'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_K3_PERIOD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_K3_ASG_LE_YTD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_L_DESCRIPTION'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_L_PERIOD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_IR56_L_ASG_LE_YTD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_QUARTERS_PROVIDED'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_QUARTERS_1_ADDRESS'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_QUARTERS_1_NATURE'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_QUARTERS_1_PERIOD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_QUARTERS_1_ER_TO_LL_LE_YTD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_QUARTERS_1_EE_TO_LL_LE_YTD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_QUARTERS_1_REFUND_TO_EE_LE_YTD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_QUARTERS_1_EE_TO_ER_LE_YTD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_QUARTERS_2_ADDRESS'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_QUARTERS_2_NATURE'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_QUARTERS_2_PERIOD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_QUARTERS_2_ER_TO_LL_LE_YTD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_QUARTERS_2_EE_TO_LL_LE_YTD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_QUARTERS_2_REFUND_TO_EE_LE_YTD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_QUARTERS_2_EE_TO_ER_LE_YTD'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_OVERSEAS_CONCERN'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_OVERSEAS_NAME'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_OVERSEAS_ADDRESS'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_OVERSEAS_AMOUNT'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_REMARKS'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_DESIGNATION'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_CONTACT'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_ARCHIVE_MESSAGE'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_LAST_RUN_DATE'
, PAA.ASSIGNMENT_ACTION_ID)
, PAY_HK_IR56_REPORT.GET_ARCHIVE_VALUE('X_HK_LAST_RUN_TYPE'
, PAA.ASSIGNMENT_ACTION_ID)
FROM PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
WHERE PAA.PAYROLL_ACTION_ID = PPA.PAYROLL_ACTION_ID
AND PPA.ACTION_TYPE = 'X'
AND PPA.ACTION_STATUS = 'C'
AND PAA.ACTION_STATUS = 'C'
AND PPA.REPORT_TYPE ='HK_IR56B_ARCHIVE'