Product: | PAY - Payroll |
---|---|
Description: | Hong Kong localisation view. |
Implementation/DBA Data: | APPS.PAY_HK_IR56_ARCHIVES_V |
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)
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'