eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PAY_AU_EOY_VALUES_V

Source

View Text - Preformatted


SELECT paa.rowid assignment_rowid ,pac.assignment_action_id ,pac.assignment_id ,pay_au_payment_summary.get_archive_value('X_REPORTING_FLAG', pac.assignment_action_id) X_REPORTING_FLAG ,pay_au_payment_summary.get_archive_value('X_CURR_TERM_0_BAL_FLAG', pac.assignment_action_id) X_CURR_TERM_0_BAL_FLAG ,ppa.payroll_action_id ,pay_core_utils.get_parameter('FINANCIAL_YEAR',ppa.legislative_parameters) FINANCIAL_YEAR ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa.legislative_parameters) REGISTERED_EMPLOYER ,pay_au_payment_summary.get_archive_value('X_REPORT_END_DATE', pac.assignment_action_id) X_REPORT_END_DATE ,pay_au_payment_summary.get_archive_value('X_SUPPLIER_NUMBER', pac.assignment_action_id) X_SUPPLIER_NUMBER ,pay_au_payment_summary.get_archive_value('X_SUPPLIER_NAME', pac.assignment_action_id) X_SUPPLIER_NAME ,pay_au_payment_summary.get_archive_value('X_SUPPLIER_CONTACT_NAME', pac.assignment_action_id) X_SUPPLIER_CONTACT_NAME ,pay_au_payment_summary.get_archive_value('X_SUPPLIER_CONTACT_TELEPHONE', pac.assignment_action_id) X_SUPPLIER_CONTACT_TELEPHONE ,pay_au_payment_summary.get_archive_value('X_SUPPLIER_ADDRESS_1', pac.assignment_action_id) X_SUPPLIER_ADDRESS_1 ,pay_au_payment_summary.get_archive_value('X_SUPPLIER_ADDRESS_2', pac.assignment_action_id) X_SUPPLIER_ADDRESS_2 ,pay_au_payment_summary.get_archive_value('X_SUPPLIER_ADDRESS_2', pac.assignment_action_id) X_SUPPLIER_ADDRESS_3 ,pay_au_payment_summary.get_archive_value('X_SUPPLIER_SUBURB', pac.assignment_action_id) X_SUPPLIER_SUBURB ,pay_au_payment_summary.get_archive_value('X_SUPPLIER_STATE', pac.assignment_action_id) X_SUPPLIER_STATE ,pay_au_payment_summary.get_archive_value('X_SUPPLIER_POSTCODE', pac.assignment_action_id) X_SUPPLIER_POSTCODE ,pay_au_payment_summary.get_archive_value('X_SUPPLIER_COUNTRY', pac.assignment_action_id) X_SUPPLIER_COUNTRY ,pay_au_payment_summary.get_archive_value('X_SUPPLIER_EMAIL', pac.assignment_action_id) X_SUPPLIER_EMAIL ,pay_au_payment_summary.get_archive_value('X_EMPLOYER_GROUP_ACT_NO', pac.assignment_action_id) X_EMPLOYER_GROUP_ACT_NO ,pay_au_payment_summary.get_archive_value('X_EMPLOYER_BUSINESS_NAME', pac.assignment_action_id) X_EMPLOYER_BUSINESS_NAME ,pay_au_payment_summary.get_archive_value('X_EMPLOYER_TRADING_NAME', pac.assignment_action_id) X_EMPLOYER_TRADING_NAME ,pay_au_payment_summary.get_archive_value('X_EMPLOYER_ABN', pac.assignment_action_id) X_EMPLOYER_ABN ,pay_au_payment_summary.get_archive_value('X_EMPLOYER_CONTACT_NAME', pac.assignment_action_id) X_EMPLOYER_CONTACT_NAME ,pay_au_payment_summary.get_archive_value('X_EMPLOYER_CONTACT_TELEPHONE', pac.assignment_action_id) X_EMPLOYER_CONTACT_TELEPHONE ,pay_au_payment_summary.get_archive_value('X_EMPLOYER_ADDRESS_1', pac.assignment_action_id) X_EMPLOYER_ADDRESS_1 ,pay_au_payment_summary.get_archive_value('X_EMPLOYER_ADDRESS_2', pac.assignment_action_id) X_EMPLOYER_ADDRESS_2 ,pay_au_payment_summary.get_archive_value('X_EMPLOYER_ADDRESS_3', pac.assignment_action_id) X_EMPLOYER_ADDRESS_3 ,pay_au_payment_summary.get_archive_value('X_EMPLOYER_SUBURB', pac.assignment_action_id) X_EMPLOYER_SUBURB ,pay_au_payment_summary.get_archive_value('X_EMPLOYER_STATE', pac.assignment_action_id) X_EMPLOYER_STATE ,pay_au_payment_summary.get_archive_value('X_EMPLOYER_POSTCODE', pac.assignment_action_id) X_EMPLOYER_POSTCODE ,pay_au_payment_summary.get_archive_value('X_EMPLOYER_COUNTRY', pac.assignment_action_id) X_EMPLOYER_COUNTRY ,pay_au_payment_summary.get_archive_value('X_EMPLOYER_BRANCH_NUMBER', pac.assignment_action_id) X_EMPLOYER_BRANCH_NUMBER ,pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_SIGNATORY', pac.assignment_action_id) X_PAYMENT_SUMMARY_SIGNATORY ,pay_au_payment_summary.get_archive_value('X_EMPLOYEE_TAX_FILE_NUMBER', pac.assignment_action_id) X_EMPLOYEE_TAX_FILE_NUMBER ,pay_au_payment_summary.get_archive_value('X_EMPLOYEE_FIRST_NAME', pac.assignment_action_id) X_EMPLOYEE_FIRST_NAME ,pay_au_payment_summary.get_archive_value('X_EMPLOYEE_MIDDLE_NAME', pac.assignment_action_id) X_EMPLOYEE_MIDDLE_NAME ,pay_au_payment_summary.get_archive_value('X_EMPLOYEE_SURNAME', pac.assignment_action_id) X_EMPLOYEE_SURNAME ,pay_au_payment_summary.get_archive_value('X_EMPLOYEE_ABN', pac.assignment_action_id) X_EMPLOYEE_ABN ,pay_au_payment_summary.get_archive_value('X_EMPLOYEE_ADDRESS_1', pac.assignment_action_id) X_EMPLOYEE_ADDRESS_1 ,pay_au_payment_summary.get_archive_value('X_EMPLOYEE_ADDRESS_2', pac.assignment_action_id) X_EMPLOYEE_ADDRESS_2 ,pay_au_payment_summary.get_archive_value('X_EMPLOYEE_ADDRESS_3', pac.assignment_action_id) X_EMPLOYEE_ADDRESS_3 ,pay_au_payment_summary.get_archive_value('X_EMPLOYEE_SUBURB', pac.assignment_action_id) X_EMPLOYEE_SUBURB ,pay_au_payment_summary.get_archive_value('X_EMPLOYEE_STATE', pac.assignment_action_id) X_EMPLOYEE_STATE ,pay_au_payment_summary.get_archive_value('X_EMPLOYEE_POSTCODE', pac.assignment_action_id) X_EMPLOYEE_POSTCODE ,pay_au_payment_summary.get_archive_value('X_EMPLOYEE_COUNTRY', pac.assignment_action_id) X_EMPLOYEE_COUNTRY ,pay_au_payment_summary.get_archive_value('X_EMPLOYEE_START_DATE', pac.assignment_action_id) X_EMPLOYEE_START_DATE ,pay_au_payment_summary.get_archive_value('X_EMPLOYEE_END_DATE', pac.assignment_action_id) X_EMPLOYEE_END_DATE ,pay_au_payment_summary.get_archive_value('X_EMPLOYEE_DATE_OF_BIRTH', pac.assignment_action_id) X_EMPLOYEE_DATE_OF_BIRTH ,pay_au_payment_summary.get_archive_value('X_EMPLOYEE_FINAL_PROCESS_DATE', pac.assignment_action_id) X_EMPLOYEE_FINAL_PROCESS_DATE ,pay_au_payment_summary.get_archive_value('X_UNION_NAMES', pac.assignment_action_id) X_UNION_NAMES ,pay_au_payment_summary.get_archive_value('X_ETP_TAX_FILE_NUMBER', pac.assignment_action_id) X_ETP_TAX_FILE_NUMBER ,pay_au_payment_summary.get_archive_value('X_ETP_EMPLOYEE_FIRST_NAME', pac.assignment_action_id) X_ETP_EMPLOYEE_FIRST_NAME ,pay_au_payment_summary.get_archive_value('X_ETP_EMPLOYEE_MIDDLE_NAME', pac.assignment_action_id) X_ETP_EMPLOYEE_MIDDLE_NAME ,pay_au_payment_summary.get_archive_value('X_ETP_EMPLOYEE_SURNAME', pac.assignment_action_id) X_ETP_EMPLOYEE_SURNAME ,pay_au_payment_summary.get_archive_value('X_ETP_EMPLOYEE_ADDRESS_1', pac.assignment_action_id) X_ETP_EMPLOYEE_ADDRESS_1 ,pay_au_payment_summary.get_archive_value('X_ETP_EMPLOYEE_ADDRESS_2', pac.assignment_action_id) X_ETP_EMPLOYEE_ADDRESS_2 ,pay_au_payment_summary.get_archive_value('X_ETP_EMPLOYEE_ADDRESS_3', pac.assignment_action_id) X_ETP_EMPLOYEE_ADDRESS_3 ,pay_au_payment_summary.get_archive_value('X_ETP_EMPLOYEE_SUBURB', pac.assignment_action_id) X_ETP_EMPLOYEE_SUBURB ,pay_au_payment_summary.get_archive_value('X_ETP_EMPLOYEE_STATE', pac.assignment_action_id) X_ETP_EMPLOYEE_STATE ,pay_au_payment_summary.get_archive_value('X_ETP_EMPLOYEE_POSTCODE', pac.assignment_action_id) X_ETP_EMPLOYEE_POSTCODE ,pay_au_payment_summary.get_archive_value('X_ETP_EMPLOYEE_COUNTRY', pac.assignment_action_id) X_ETP_EMPLOYEE_COUNTRY ,pay_au_payment_summary.get_archive_value('X_ETP_EMPLOYEE_START_DATE', pac.assignment_action_id) X_ETP_EMPLOYEE_START_DATE ,pay_au_payment_summary.get_archive_value('X_ETP_EMPLOYEE_END_DATE', pac.assignment_action_id) X_ETP_EMPLOYEE_END_DATE ,pay_au_payment_summary.get_archive_value('X_ETP_EMPLOYEE_DATE_OF_BIRTH', pac.assignment_action_id) X_ETP_EMPLOYEE_DATE_OF_BIRTH ,pay_au_payment_summary.get_archive_value('X_ETP_EMPLOYEE_END_DATE', pac.assignment_action_id) PAY_DATE ,pay_au_payment_summary.get_archive_value('X_EMPLOYEE_LE_END_DATE', pac.assignment_action_id) X_EMPLOYEE_LE_END_DATE ,pay_au_payment_summary.get_archive_value('X_EMPLOYEE_LE_START_DATE', pac.assignment_action_id) X_EMPLOYEE_LE_START_DATE ,pay_au_payment_summary.get_archive_value('X_ETP_DEATH_BENEFIT', pac.assignment_action_id) X_ETP_DEATH_BENEFIT ,pay_au_payment_summary.get_archive_value('X_ETP_DEATH_BENEFIT_TYPE', pac.assignment_action_id) X_ETP_DEATH_BENEFIT_TYPE ,pay_au_payment_summary.get_archive_value('X_TRANSITIONAL_ETP', pac.assignment_action_id) X_TRANSITIONAL_ETP ,pay_au_payment_summary.get_archive_value('X_PART_OF_PREVIOUS_ETP', pac.assignment_action_id) X_PART_OF_PREVIOUS_ETP ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_1_ASG_YTD', pac.assignment_action_id),0) X_ALLOWANCE_1_ASG_YTD ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_2_ASG_YTD', pac.assignment_action_id),0) X_ALLOWANCE_2_ASG_YTD ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_3_ASG_YTD', pac.assignment_action_id),0) X_ALLOWANCE_3_ASG_YTD ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_4_ASG_YTD', pac.assignment_action_id),0) X_ALLOWANCE_4_ASG_YTD ,NVL(pay_au_payment_summary.get_archive_value('X_FRINGE_BENEFITS_ASG_YTD', pac.assignment_action_id),0) X_FRINGE_BENEFITS_ASG_YTD ,NVL(pay_au_payment_summary.get_archive_value('X_CDEP_ASG_YTD', pac.assignment_action_id),0) X_CDEP_ASG_YTD ,NVL(pay_au_payment_summary.get_archive_value('X_EARNINGS_TOTAL_ASG_YTD', pac.assignment_action_id),0) X_EARNINGS_TOTAL_ASG_YTD ,NVL(pay_au_payment_summary.get_archive_value('X_WORKPLACE_GIVING_DEDUCTIONS_ASG_YTD', pac.assignment_action_id),0) X_WORKPLACE_DEDUCTIONS_ASG_YTD ,NVL(pay_au_payment_summary.get_archive_value('X_LUMP_SUM_A_DEDUCTIONS_ASG_YTD', pac.assignment_action_id),0) X_LUMP_SUM_A_DEDUCTION_ASG_YTD ,NVL(pay_au_payment_summary.get_archive_value('X_LUMP_SUM_A_PAYMENTS_ASG_YTD', pac.assignment_action_id),0) X_LUMP_SUM_A_PAYMENTS_ASG_YTD ,NVL(pay_au_payment_summary.get_archive_value('X_LUMP_SUM_B_DEDUCTIONS_ASG_YTD', pac.assignment_action_id),0) X_LUMP_SUM_B_DEDUCTION_ASG_YTD ,NVL(pay_au_payment_summary.get_archive_value('X_LUMP_SUM_B_PAYMENTS_ASG_YTD', pac.assignment_action_id),0) X_LUMP_SUM_B_PAYMENTS_ASG_YTD ,NVL(pay_au_payment_summary.get_archive_value('X_LUMP_SUM_D_PAYMENTS_ASG_YTD', pac.assignment_action_id),0) X_LUMP_SUM_D_PAYMENTS_ASG_YTD ,NVL(pay_au_payment_summary.get_archive_value('X_LUMP_SUM_E_PAYMENTS_ASG_YTD', pac.assignment_action_id),0) X_LUMP_SUM_E_PAYMENTS_ASG_YTD ,NVL(pay_au_payment_summary.get_archive_value('X_TOTAL_TAX_DEDUCTIONS_ASG_YTD', pac.assignment_action_id),0) X_TOTAL_TAX_DEDUCTIONS_ASG_YTD ,NVL(pay_au_payment_summary.get_archive_value('X_OTHER_INCOME_ASG_YTD', pac.assignment_action_id),0) X_OTHER_INCOME_ASG_YTD ,NVL(pay_au_payment_summary.get_archive_value('X_UNION_FEES_ASG_YTD', pac.assignment_action_id),0) X_UNION_FEES_ASG_YTD ,NVL(pay_au_payment_summary.get_archive_value('X_INVALIDITY_PAYMENTS_ASG_YTD', pac.assignment_action_id),0) X_INVALIDITY_PAYMENTS_ASG_YTD ,NVL(pay_au_payment_summary.get_archive_value('X_LUMP_SUM_C_PAYMENTS_ASG_YTD', pac.assignment_action_id),0) X_LUMP_SUM_C_PAYMENTS_ASG_YTD ,NVL(pay_au_payment_summary.get_archive_value('X_PRE_JUL_83_COMPONENT_ASG_YTD', pac.assignment_action_id),0) X_PRE_JUL_83_COMPONENT_ASG_YTD ,NVL(pay_au_payment_summary.get_archive_value('X_POST_JUN_83_UNTAXED_ASG_YTD', pac.assignment_action_id),0) X_POST_JUN_83_UNTAXED_ASG_YTD ,NVL(pay_au_payment_summary.get_archive_value('X_POST_JUN_83_TAXED_ASG_YTD', pac.assignment_action_id),0) X_POST_JUN_83_TAXED_ASG_YTD ,NVL(pay_au_payment_summary.get_archive_value('X_DAYS_PRE_JUL_83', pac.assignment_action_id),0) X_DAYS_PRE_JUL_83 ,NVL(pay_au_payment_summary.get_archive_value('X_DAYS_POST_JUL_83', pac.assignment_action_id),0) X_DAYS_POST_JUL_83 ,NVL(pay_au_payment_summary.get_archive_value('X_PRE_JUL_83_COMP_TRANS_PPTERM_ASG_YTD', pac.assignment_action_id),0) X_PRE_JUL_83_COMP_TRAN_PPT ,NVL(pay_au_payment_summary.get_archive_value('X_POST_JUN_83_TAXED_TRANS_PPTERM_ASG_YTD', pac.assignment_action_id),0) X_POST_JUN_TAXED_TRAN_PPT ,NVL(pay_au_payment_summary.get_archive_value('X_PRE_JUL_83_COMP_TRANS_NOT_PPTERM_ASG_YTD', pac.assignment_action_id),0) X_PRE_JUL_83_COMP_TRAN_NOPPT ,NVL(pay_au_payment_summary.get_archive_value('X_POST_JUN_83_TAXED_TRANS_NOT_PPTERM_ASG_YTD', pac.assignment_action_id),0) X_POST_JUN_TAXED_TRAN_NOPPT ,NVL(pay_au_payment_summary.get_archive_value('X_PRE_JUL_83_COMP_NOT_TRANS_PPTERM_ASG_YTD', pac.assignment_action_id),0) X_PRE_JUL_83_COMP_NOTRAN_PPT ,NVL(pay_au_payment_summary.get_archive_value('X_POST_JUN_83_TAXED_NOT_TRANS_PPTERM_ASG_YTD', pac.assignment_action_id),0) X_POST_JUN_TAXED_NOTRAN_PPT ,NVL(pay_au_payment_summary.get_archive_value('X_PRE_JUL_83_COMP_NOT_TRANS_NOT_PPTERM_ASG_YTD', pac.assignment_action_id),0) X_PRE_JUL_83_COMP_NOTRAN_NOPPT ,NVL(pay_au_payment_summary.get_archive_value('X_POST_JUN_83_TAXED_NOT_TRANS_NOT_PPTERM_ASG_YTD', pac.assignment_action_id),0) X_POST_JUN_TAXED_NOTRAN_NOPPT ,NVL(pay_au_payment_summary.get_archive_value('X_LUMP_SUM_C_DEDUCTIONS_ASG_YTD', pac.assignment_action_id),0) X_LUMP_SUM_C_DEDUCTION_ASG_YTD ,NVL(pay_au_payment_summary.get_archive_value('X_ETP_DED_TRANS_PPTERM_ASG_YTD', pac.assignment_action_id),0) X_ETP_DED_TRAN_PPT ,NVL(pay_au_payment_summary.get_archive_value('X_ETP_DED_TRANS_NOT_PPTERM_ASG_YTD', pac.assignment_action_id),0) X_ETP_DED_TRAN_NOPPT ,NVL(pay_au_payment_summary.get_archive_value('X_ETP_DED_NOT_TRANS_PPTERM_ASG_YTD', pac.assignment_action_id),0) X_ETP_DED_NOTRAN_PPT ,NVL(pay_au_payment_summary.get_archive_value('X_ETP_DED_NOT_TRANS_NOT_PPTERM_ASG_YTD', pac.assignment_action_id),0) X_ETP_DED_NOTRAN_NOPPT ,NVL(pay_au_payment_summary.get_archive_value('X_INV_PAY_TRANS_PPTERM_ASG_YTD', pac.assignment_action_id),0) X_INV_PAY_TRAN_PPT ,NVL(pay_au_payment_summary.get_archive_value('X_INV_PAY_TRANS_NOT_PPTERM_ASG_YTD', pac.assignment_action_id),0) X_INV_PAY_TRAN_NOPPT ,NVL(pay_au_payment_summary.get_archive_value('X_INV_PAY_NOT_TRANS_PPTERM_ASG_YTD', pac.assignment_action_id),0) X_INV_PAY_NOTRAN_PPT ,NVL(pay_au_payment_summary.get_archive_value('X_INV_PAY_NOT_TRANS_NOT_PPTERM_ASG_YTD', pac.assignment_action_id),0) X_INV_PAY_NOTRAN_NOPPT ,pay_au_payment_summary.get_archive_value('X_SORT_EMPLOYEE_NUMBER', pac.assignment_action_id) X_SORT_EMPLOYEE_NUMBER ,pay_au_payment_summary.get_archive_value('X_SORT_ASSIGNMENT_LOCATION', pac.assignment_action_id) X_SORT_ASSIGNMENT_LOCATION ,pay_au_payment_summary.get_archive_value('X_SORT_PAYROLL', pac.assignment_action_id) X_SORT_PAYROLL ,pay_au_payment_summary.get_archive_value('X_SORT_EMPLOYEE_TYPE', pac.assignment_action_id) X_SORT_EMPLOYEE_TYPE ,pay_au_payment_summary.get_archive_value('X_ETP_ON_TERMINATION_PAID', pac.assignment_action_id) X_ETP_ON_TERMINATION_PAID ,pay_au_payment_summary.get_archive_value('X_ETP_EMPLOYEE_PAYMENT_DATE', pac.assignment_action_id) X_ETP_EMPLOYEE_PAYMENT_DATE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_NAME_1', pac.assignment_action_id) X_ALLOWANCE_NAME_1 ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_NAME_2', pac.assignment_action_id) X_ALLOWANCE_NAME_2 ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_NAME_3', pac.assignment_action_id) X_ALLOWANCE_NAME_3 ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_NAME_4', pac.assignment_action_id) X_ALLOWANCE_NAME_4 ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_1_NAME', pac.assignment_action_id) X_ALLOWANCE_1_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_1_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_1_VALUE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_2_NAME', pac.assignment_action_id) X_ALLOWANCE_2_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_2_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_2_VALUE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_3_NAME', pac.assignment_action_id) X_ALLOWANCE_3_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_3_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_3_VALUE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_4_NAME', pac.assignment_action_id) X_ALLOWANCE_4_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_4_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_4_VALUE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_5_NAME', pac.assignment_action_id) X_ALLOWANCE_5_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_5_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_5_VALUE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_6_NAME', pac.assignment_action_id) X_ALLOWANCE_6_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_6_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_6_VALUE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_7_NAME', pac.assignment_action_id) X_ALLOWANCE_7_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_7_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_7_VALUE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_8_NAME', pac.assignment_action_id) X_ALLOWANCE_8_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_8_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_8_VALUE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_9_NAME', pac.assignment_action_id) X_ALLOWANCE_9_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_9_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_9_VALUE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_10_NAME', pac.assignment_action_id) X_ALLOWANCE_10_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_10_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_10_VALUE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_11_NAME', pac.assignment_action_id) X_ALLOWANCE_11_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_11_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_11_VALUE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_12_NAME', pac.assignment_action_id) X_ALLOWANCE_12_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_12_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_12_VALUE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_13_NAME', pac.assignment_action_id) X_ALLOWANCE_13_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_13_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_13_VALUE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_14_NAME', pac.assignment_action_id) X_ALLOWANCE_14_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_14_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_14_VALUE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_15_NAME', pac.assignment_action_id) X_ALLOWANCE_15_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_15_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_15_VALUE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_16_NAME', pac.assignment_action_id) X_ALLOWANCE_16_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_16_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_16_VALUE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_17_NAME', pac.assignment_action_id) X_ALLOWANCE_17_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_17_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_17_VALUE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_18_NAME', pac.assignment_action_id) X_ALLOWANCE_18_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_18_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_18_VALUE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_19_NAME', pac.assignment_action_id) X_ALLOWANCE_19_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_19_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_19_VALUE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_20_NAME', pac.assignment_action_id) X_ALLOWANCE_20_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_20_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_20_VALUE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_21_NAME', pac.assignment_action_id) X_ALLOWANCE_21_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_21_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_21_VALUE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_22_NAME', pac.assignment_action_id) X_ALLOWANCE_22_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_22_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_22_VALUE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_23_NAME', pac.assignment_action_id) X_ALLOWANCE_23_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_23_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_23_VALUE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_24_NAME', pac.assignment_action_id) X_ALLOWANCE_24_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_24_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_24_VALUE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_25_NAME', pac.assignment_action_id) X_ALLOWANCE_25_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_25_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_25_VALUE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_26_NAME', pac.assignment_action_id) X_ALLOWANCE_26_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_26_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_26_VALUE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_27_NAME', pac.assignment_action_id) X_ALLOWANCE_27_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_27_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_27_VALUE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_28_NAME', pac.assignment_action_id) X_ALLOWANCE_28_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_28_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_28_VALUE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_29_NAME', pac.assignment_action_id) X_ALLOWANCE_29_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_29_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_29_VALUE ,pay_au_payment_summary.get_archive_value('X_ALLOWANCE_30_NAME', pac.assignment_action_id) X_ALLOWANCE_30_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_ALLOWANCE_30_VALUE', pac.assignment_action_id),0) X_ALLOWANCE_30_VALUE ,pay_au_payment_summary.get_archive_value('X_UNION_1_NAME', pac.assignment_action_id) X_UNION_1_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_UNION_1_VALUE', pac.assignment_action_id),0) X_UNION_1_VALUE ,pay_au_payment_summary.get_archive_value('X_UNION_2_NAME', pac.assignment_action_id) X_UNION_2_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_UNION_2_VALUE', pac.assignment_action_id),0) X_UNION_2_VALUE ,pay_au_payment_summary.get_archive_value('X_UNION_3_NAME', pac.assignment_action_id) X_UNION_3_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_UNION_3_VALUE', pac.assignment_action_id),0) X_UNION_3_VALUE ,pay_au_payment_summary.get_archive_value('X_UNION_4_NAME', pac.assignment_action_id) X_UNION_4_NAME ,NVL(pay_au_payment_summary.get_archive_value('X_UNION_4_VALUE', pac.assignment_action_id),0) X_UNION_4_VALUE ,pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', pac.assignment_action_id) X_PAYMENT_SUMMARY_TYPE ,pay_au_payment_summary.get_archive_value('X_PAYG_PAYMENT_SUMMARY_TYPE', pac.assignment_action_id) X_PAYG_PAYMENT_SUMMARY_TYPE ,pay_au_payment_summary.get_archive_value('X_ETP1_PAYMENT_SUMMARY_TYPE', pac.assignment_action_id) X_ETP1_PAYMENT_SUMMARY_TYPE ,pay_au_payment_summary.get_archive_value('X_ETP2_PAYMENT_SUMMARY_TYPE', pac.assignment_action_id) X_ETP2_PAYMENT_SUMMARY_TYPE ,pay_au_payment_summary.get_archive_value('X_ETP3_PAYMENT_SUMMARY_TYPE', pac.assignment_action_id) X_ETP3_PAYMENT_SUMMARY_TYPE ,pay_au_payment_summary.get_archive_value('X_ETP4_PAYMENT_SUMMARY_TYPE', pac.assignment_action_id) X_ETP4_PAYMENT_SUMMARY_TYPE ,ppa.report_type ,paa.assignment_number from pay_assignment_actions pac, pay_payroll_actions ppa, per_all_assignments_f paa WHERE ppa.payroll_action_id = pac.payroll_action_id and pac.assignment_id = paa.assignment_id and ppa.report_type IN ('AU_PAYMENT_SUMMARY','AU_PAY_SUMM_AMEND') and ppa.action_type = 'X' and ppa.action_status ='C' and pac.assignment_action_id in (select MAX(ppac.assignment_action_id) from pay_assignment_actions ppac, pay_payroll_actions ppaa where ppaa.action_type = 'X' and ppaa.action_status = 'C' and ( ppaa.report_type = 'AU_PAYMENT_SUMMARY' OR (ppaa.report_type = 'AU_PAY_SUMM_AMEND' AND pay_au_payment_summary.get_archive_value('X_PAYMENT_SUMMARY_TYPE', ppac.assignment_action_id) = 'A') ) and ppaa.payroll_action_id = ppac.payroll_action_id and pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppaa.legislative_parameters) = pay_core_utils.get_parameter('REGISTERED_EMPLOYER',ppa.legislative_parameters) GROUP BY ppac.assignment_id ) and paa.effective_start_date in (select max(effective_start_date) from per_all_assignments_f paa1 where paa1.assignment_id = paa.assignment_id )

View Text - HTML Formatted

SELECT PAA.ROWID ASSIGNMENT_ROWID
, PAC.ASSIGNMENT_ACTION_ID
, PAC.ASSIGNMENT_ID
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_REPORTING_FLAG'
, PAC.ASSIGNMENT_ACTION_ID) X_REPORTING_FLAG
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_CURR_TERM_0_BAL_FLAG'
, PAC.ASSIGNMENT_ACTION_ID) X_CURR_TERM_0_BAL_FLAG
, PPA.PAYROLL_ACTION_ID
, PAY_CORE_UTILS.GET_PARAMETER('FINANCIAL_YEAR'
, PPA.LEGISLATIVE_PARAMETERS) FINANCIAL_YEAR
, PAY_CORE_UTILS.GET_PARAMETER('REGISTERED_EMPLOYER'
, PPA.LEGISLATIVE_PARAMETERS) REGISTERED_EMPLOYER
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_REPORT_END_DATE'
, PAC.ASSIGNMENT_ACTION_ID) X_REPORT_END_DATE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_SUPPLIER_NUMBER'
, PAC.ASSIGNMENT_ACTION_ID) X_SUPPLIER_NUMBER
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_SUPPLIER_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_SUPPLIER_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_SUPPLIER_CONTACT_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_SUPPLIER_CONTACT_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_SUPPLIER_CONTACT_TELEPHONE'
, PAC.ASSIGNMENT_ACTION_ID) X_SUPPLIER_CONTACT_TELEPHONE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_SUPPLIER_ADDRESS_1'
, PAC.ASSIGNMENT_ACTION_ID) X_SUPPLIER_ADDRESS_1
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_SUPPLIER_ADDRESS_2'
, PAC.ASSIGNMENT_ACTION_ID) X_SUPPLIER_ADDRESS_2
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_SUPPLIER_ADDRESS_2'
, PAC.ASSIGNMENT_ACTION_ID) X_SUPPLIER_ADDRESS_3
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_SUPPLIER_SUBURB'
, PAC.ASSIGNMENT_ACTION_ID) X_SUPPLIER_SUBURB
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_SUPPLIER_STATE'
, PAC.ASSIGNMENT_ACTION_ID) X_SUPPLIER_STATE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_SUPPLIER_POSTCODE'
, PAC.ASSIGNMENT_ACTION_ID) X_SUPPLIER_POSTCODE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_SUPPLIER_COUNTRY'
, PAC.ASSIGNMENT_ACTION_ID) X_SUPPLIER_COUNTRY
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_SUPPLIER_EMAIL'
, PAC.ASSIGNMENT_ACTION_ID) X_SUPPLIER_EMAIL
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYER_GROUP_ACT_NO'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYER_GROUP_ACT_NO
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYER_BUSINESS_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYER_BUSINESS_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYER_TRADING_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYER_TRADING_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYER_ABN'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYER_ABN
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYER_CONTACT_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYER_CONTACT_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYER_CONTACT_TELEPHONE'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYER_CONTACT_TELEPHONE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYER_ADDRESS_1'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYER_ADDRESS_1
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYER_ADDRESS_2'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYER_ADDRESS_2
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYER_ADDRESS_3'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYER_ADDRESS_3
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYER_SUBURB'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYER_SUBURB
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYER_STATE'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYER_STATE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYER_POSTCODE'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYER_POSTCODE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYER_COUNTRY'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYER_COUNTRY
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYER_BRANCH_NUMBER'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYER_BRANCH_NUMBER
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_PAYMENT_SUMMARY_SIGNATORY'
, PAC.ASSIGNMENT_ACTION_ID) X_PAYMENT_SUMMARY_SIGNATORY
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYEE_TAX_FILE_NUMBER'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYEE_TAX_FILE_NUMBER
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYEE_FIRST_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYEE_FIRST_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYEE_MIDDLE_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYEE_MIDDLE_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYEE_SURNAME'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYEE_SURNAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYEE_ABN'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYEE_ABN
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYEE_ADDRESS_1'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYEE_ADDRESS_1
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYEE_ADDRESS_2'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYEE_ADDRESS_2
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYEE_ADDRESS_3'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYEE_ADDRESS_3
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYEE_SUBURB'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYEE_SUBURB
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYEE_STATE'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYEE_STATE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYEE_POSTCODE'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYEE_POSTCODE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYEE_COUNTRY'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYEE_COUNTRY
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYEE_START_DATE'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYEE_START_DATE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYEE_END_DATE'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYEE_END_DATE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYEE_DATE_OF_BIRTH'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYEE_DATE_OF_BIRTH
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYEE_FINAL_PROCESS_DATE'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYEE_FINAL_PROCESS_DATE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_UNION_NAMES'
, PAC.ASSIGNMENT_ACTION_ID) X_UNION_NAMES
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ETP_TAX_FILE_NUMBER'
, PAC.ASSIGNMENT_ACTION_ID) X_ETP_TAX_FILE_NUMBER
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ETP_EMPLOYEE_FIRST_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ETP_EMPLOYEE_FIRST_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ETP_EMPLOYEE_MIDDLE_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ETP_EMPLOYEE_MIDDLE_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ETP_EMPLOYEE_SURNAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ETP_EMPLOYEE_SURNAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ETP_EMPLOYEE_ADDRESS_1'
, PAC.ASSIGNMENT_ACTION_ID) X_ETP_EMPLOYEE_ADDRESS_1
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ETP_EMPLOYEE_ADDRESS_2'
, PAC.ASSIGNMENT_ACTION_ID) X_ETP_EMPLOYEE_ADDRESS_2
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ETP_EMPLOYEE_ADDRESS_3'
, PAC.ASSIGNMENT_ACTION_ID) X_ETP_EMPLOYEE_ADDRESS_3
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ETP_EMPLOYEE_SUBURB'
, PAC.ASSIGNMENT_ACTION_ID) X_ETP_EMPLOYEE_SUBURB
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ETP_EMPLOYEE_STATE'
, PAC.ASSIGNMENT_ACTION_ID) X_ETP_EMPLOYEE_STATE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ETP_EMPLOYEE_POSTCODE'
, PAC.ASSIGNMENT_ACTION_ID) X_ETP_EMPLOYEE_POSTCODE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ETP_EMPLOYEE_COUNTRY'
, PAC.ASSIGNMENT_ACTION_ID) X_ETP_EMPLOYEE_COUNTRY
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ETP_EMPLOYEE_START_DATE'
, PAC.ASSIGNMENT_ACTION_ID) X_ETP_EMPLOYEE_START_DATE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ETP_EMPLOYEE_END_DATE'
, PAC.ASSIGNMENT_ACTION_ID) X_ETP_EMPLOYEE_END_DATE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ETP_EMPLOYEE_DATE_OF_BIRTH'
, PAC.ASSIGNMENT_ACTION_ID) X_ETP_EMPLOYEE_DATE_OF_BIRTH
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ETP_EMPLOYEE_END_DATE'
, PAC.ASSIGNMENT_ACTION_ID) PAY_DATE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYEE_LE_END_DATE'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYEE_LE_END_DATE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EMPLOYEE_LE_START_DATE'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYEE_LE_START_DATE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ETP_DEATH_BENEFIT'
, PAC.ASSIGNMENT_ACTION_ID) X_ETP_DEATH_BENEFIT
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ETP_DEATH_BENEFIT_TYPE'
, PAC.ASSIGNMENT_ACTION_ID) X_ETP_DEATH_BENEFIT_TYPE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_TRANSITIONAL_ETP'
, PAC.ASSIGNMENT_ACTION_ID) X_TRANSITIONAL_ETP
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_PART_OF_PREVIOUS_ETP'
, PAC.ASSIGNMENT_ACTION_ID) X_PART_OF_PREVIOUS_ETP
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_1_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_1_ASG_YTD
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_2_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_2_ASG_YTD
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_3_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_3_ASG_YTD
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_4_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_4_ASG_YTD
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_FRINGE_BENEFITS_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_FRINGE_BENEFITS_ASG_YTD
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_CDEP_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_CDEP_ASG_YTD
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_EARNINGS_TOTAL_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_EARNINGS_TOTAL_ASG_YTD
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_WORKPLACE_GIVING_DEDUCTIONS_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_WORKPLACE_DEDUCTIONS_ASG_YTD
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_LUMP_SUM_A_DEDUCTIONS_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_LUMP_SUM_A_DEDUCTION_ASG_YTD
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_LUMP_SUM_A_PAYMENTS_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_LUMP_SUM_A_PAYMENTS_ASG_YTD
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_LUMP_SUM_B_DEDUCTIONS_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_LUMP_SUM_B_DEDUCTION_ASG_YTD
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_LUMP_SUM_B_PAYMENTS_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_LUMP_SUM_B_PAYMENTS_ASG_YTD
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_LUMP_SUM_D_PAYMENTS_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_LUMP_SUM_D_PAYMENTS_ASG_YTD
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_LUMP_SUM_E_PAYMENTS_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_LUMP_SUM_E_PAYMENTS_ASG_YTD
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_TOTAL_TAX_DEDUCTIONS_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_TOTAL_TAX_DEDUCTIONS_ASG_YTD
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_OTHER_INCOME_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_OTHER_INCOME_ASG_YTD
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_UNION_FEES_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_UNION_FEES_ASG_YTD
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_INVALIDITY_PAYMENTS_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_INVALIDITY_PAYMENTS_ASG_YTD
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_LUMP_SUM_C_PAYMENTS_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_LUMP_SUM_C_PAYMENTS_ASG_YTD
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_PRE_JUL_83_COMPONENT_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_PRE_JUL_83_COMPONENT_ASG_YTD
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_POST_JUN_83_UNTAXED_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_POST_JUN_83_UNTAXED_ASG_YTD
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_POST_JUN_83_TAXED_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_POST_JUN_83_TAXED_ASG_YTD
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_DAYS_PRE_JUL_83'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_DAYS_PRE_JUL_83
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_DAYS_POST_JUL_83'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_DAYS_POST_JUL_83
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_PRE_JUL_83_COMP_TRANS_PPTERM_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_PRE_JUL_83_COMP_TRAN_PPT
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_POST_JUN_83_TAXED_TRANS_PPTERM_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_POST_JUN_TAXED_TRAN_PPT
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_PRE_JUL_83_COMP_TRANS_NOT_PPTERM_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_PRE_JUL_83_COMP_TRAN_NOPPT
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_POST_JUN_83_TAXED_TRANS_NOT_PPTERM_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_POST_JUN_TAXED_TRAN_NOPPT
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_PRE_JUL_83_COMP_NOT_TRANS_PPTERM_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_PRE_JUL_83_COMP_NOTRAN_PPT
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_POST_JUN_83_TAXED_NOT_TRANS_PPTERM_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_POST_JUN_TAXED_NOTRAN_PPT
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_PRE_JUL_83_COMP_NOT_TRANS_NOT_PPTERM_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_PRE_JUL_83_COMP_NOTRAN_NOPPT
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_POST_JUN_83_TAXED_NOT_TRANS_NOT_PPTERM_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_POST_JUN_TAXED_NOTRAN_NOPPT
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_LUMP_SUM_C_DEDUCTIONS_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_LUMP_SUM_C_DEDUCTION_ASG_YTD
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ETP_DED_TRANS_PPTERM_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ETP_DED_TRAN_PPT
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ETP_DED_TRANS_NOT_PPTERM_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ETP_DED_TRAN_NOPPT
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ETP_DED_NOT_TRANS_PPTERM_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ETP_DED_NOTRAN_PPT
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ETP_DED_NOT_TRANS_NOT_PPTERM_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ETP_DED_NOTRAN_NOPPT
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_INV_PAY_TRANS_PPTERM_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_INV_PAY_TRAN_PPT
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_INV_PAY_TRANS_NOT_PPTERM_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_INV_PAY_TRAN_NOPPT
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_INV_PAY_NOT_TRANS_PPTERM_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_INV_PAY_NOTRAN_PPT
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_INV_PAY_NOT_TRANS_NOT_PPTERM_ASG_YTD'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_INV_PAY_NOTRAN_NOPPT
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_SORT_EMPLOYEE_NUMBER'
, PAC.ASSIGNMENT_ACTION_ID) X_SORT_EMPLOYEE_NUMBER
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_SORT_ASSIGNMENT_LOCATION'
, PAC.ASSIGNMENT_ACTION_ID) X_SORT_ASSIGNMENT_LOCATION
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_SORT_PAYROLL'
, PAC.ASSIGNMENT_ACTION_ID) X_SORT_PAYROLL
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_SORT_EMPLOYEE_TYPE'
, PAC.ASSIGNMENT_ACTION_ID) X_SORT_EMPLOYEE_TYPE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ETP_ON_TERMINATION_PAID'
, PAC.ASSIGNMENT_ACTION_ID) X_ETP_ON_TERMINATION_PAID
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ETP_EMPLOYEE_PAYMENT_DATE'
, PAC.ASSIGNMENT_ACTION_ID) X_ETP_EMPLOYEE_PAYMENT_DATE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_NAME_1'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_NAME_1
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_NAME_2'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_NAME_2
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_NAME_3'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_NAME_3
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_NAME_4'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_NAME_4
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_1_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_1_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_1_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_1_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_2_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_2_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_2_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_2_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_3_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_3_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_3_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_3_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_4_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_4_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_4_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_4_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_5_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_5_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_5_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_5_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_6_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_6_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_6_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_6_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_7_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_7_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_7_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_7_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_8_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_8_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_8_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_8_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_9_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_9_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_9_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_9_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_10_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_10_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_10_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_10_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_11_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_11_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_11_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_11_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_12_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_12_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_12_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_12_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_13_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_13_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_13_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_13_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_14_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_14_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_14_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_14_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_15_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_15_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_15_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_15_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_16_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_16_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_16_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_16_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_17_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_17_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_17_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_17_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_18_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_18_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_18_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_18_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_19_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_19_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_19_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_19_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_20_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_20_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_20_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_20_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_21_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_21_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_21_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_21_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_22_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_22_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_22_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_22_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_23_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_23_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_23_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_23_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_24_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_24_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_24_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_24_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_25_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_25_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_25_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_25_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_26_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_26_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_26_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_26_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_27_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_27_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_27_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_27_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_28_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_28_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_28_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_28_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_29_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_29_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_29_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_29_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_30_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_30_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_30_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_30_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_UNION_1_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_UNION_1_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_UNION_1_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_UNION_1_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_UNION_2_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_UNION_2_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_UNION_2_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_UNION_2_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_UNION_3_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_UNION_3_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_UNION_3_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_UNION_3_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_UNION_4_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_UNION_4_NAME
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_UNION_4_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_UNION_4_VALUE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_PAYMENT_SUMMARY_TYPE'
, PAC.ASSIGNMENT_ACTION_ID) X_PAYMENT_SUMMARY_TYPE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_PAYG_PAYMENT_SUMMARY_TYPE'
, PAC.ASSIGNMENT_ACTION_ID) X_PAYG_PAYMENT_SUMMARY_TYPE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ETP1_PAYMENT_SUMMARY_TYPE'
, PAC.ASSIGNMENT_ACTION_ID) X_ETP1_PAYMENT_SUMMARY_TYPE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ETP2_PAYMENT_SUMMARY_TYPE'
, PAC.ASSIGNMENT_ACTION_ID) X_ETP2_PAYMENT_SUMMARY_TYPE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ETP3_PAYMENT_SUMMARY_TYPE'
, PAC.ASSIGNMENT_ACTION_ID) X_ETP3_PAYMENT_SUMMARY_TYPE
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ETP4_PAYMENT_SUMMARY_TYPE'
, PAC.ASSIGNMENT_ACTION_ID) X_ETP4_PAYMENT_SUMMARY_TYPE
, PPA.REPORT_TYPE
, PAA.ASSIGNMENT_NUMBER
FROM PAY_ASSIGNMENT_ACTIONS PAC
, PAY_PAYROLL_ACTIONS PPA
, PER_ALL_ASSIGNMENTS_F PAA
WHERE PPA.PAYROLL_ACTION_ID = PAC.PAYROLL_ACTION_ID
AND PAC.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND PPA.REPORT_TYPE IN ('AU_PAYMENT_SUMMARY'
, 'AU_PAY_SUMM_AMEND')
AND PPA.ACTION_TYPE = 'X'
AND PPA.ACTION_STATUS ='C'
AND PAC.ASSIGNMENT_ACTION_ID IN (SELECT MAX(PPAC.ASSIGNMENT_ACTION_ID)
FROM PAY_ASSIGNMENT_ACTIONS PPAC
, PAY_PAYROLL_ACTIONS PPAA
WHERE PPAA.ACTION_TYPE = 'X'
AND PPAA.ACTION_STATUS = 'C'
AND ( PPAA.REPORT_TYPE = 'AU_PAYMENT_SUMMARY' OR (PPAA.REPORT_TYPE = 'AU_PAY_SUMM_AMEND'
AND PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_PAYMENT_SUMMARY_TYPE'
, PPAC.ASSIGNMENT_ACTION_ID) = 'A') )
AND PPAA.PAYROLL_ACTION_ID = PPAC.PAYROLL_ACTION_ID
AND PAY_CORE_UTILS.GET_PARAMETER('REGISTERED_EMPLOYER'
, PPAA.LEGISLATIVE_PARAMETERS) = PAY_CORE_UTILS.GET_PARAMETER('REGISTERED_EMPLOYER'
, PPA.LEGISLATIVE_PARAMETERS) GROUP BY PPAC.ASSIGNMENT_ID )
AND PAA.EFFECTIVE_START_DATE IN (SELECT MAX(EFFECTIVE_START_DATE)
FROM PER_ALL_ASSIGNMENTS_F PAA1
WHERE PAA1.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID )