View: PAY_AU_SELFP_VALUES_V

Product:	PAY - Payroll
Description:	Australian localisation view.
Implementation/DBA Data:	APPS.PAY_AU_SELFP_VALUES_V

View Text

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_MANUAL_PS'
, PAC.ASSIGNMENT_ACTION_ID) X_EMPLOYEE_MANUAL_PS
, 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_ALLOWANCE_1_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_1_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_2_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_2_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_3_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_3_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_4_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_4_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_5_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_5_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_6_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_6_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_7_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_7_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_8_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_8_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_9_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_9_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_10_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_10_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_11_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_11_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_12_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_12_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_13_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_13_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_14_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_14_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_15_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_15_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_16_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_16_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_17_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_17_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_18_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_18_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_19_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_19_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_20_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_20_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_21_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_21_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_22_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_22_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_23_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_23_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_24_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_24_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_25_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_25_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_26_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_26_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_27_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_27_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_28_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_28_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_29_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_29_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_30_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_ALLOWANCE_30_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_UNION_1_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_UNION_1_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_UNION_2_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_UNION_2_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_UNION_3_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_UNION_3_VALUE
, NVL(PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_UNION_4_VALUE'
, PAC.ASSIGNMENT_ACTION_ID)
, 0) X_UNION_4_VALUE
, 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(TRUNC(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
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_2_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_2_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_3_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_3_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_4_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_4_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_5_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_5_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_6_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_6_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_7_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_7_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_8_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_8_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_9_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_9_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_10_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_10_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_11_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_11_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_12_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_12_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_13_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_13_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_14_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_14_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_15_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_15_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_16_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_16_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_17_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_17_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_18_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_18_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_19_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_19_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_20_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_20_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_21_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_21_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_22_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_22_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_23_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_23_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_24_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_24_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_25_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_25_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_26_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_26_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_27_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_27_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_28_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_28_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_29_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_29_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_ALLOWANCE_30_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_ALLOWANCE_30_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_UNION_1_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_UNION_1_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_UNION_2_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_UNION_2_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_UNION_3_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_UNION_3_NAME
, PAY_AU_PAYMENT_SUMMARY.GET_ARCHIVE_VALUE('X_UNION_4_NAME'
, PAC.ASSIGNMENT_ACTION_ID) X_UNION_4_NAME
, 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 ='AU_PAYMENT_SUMMARY'
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'
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)
AND PAY_CORE_UTILS.GET_PARAMETER('FINANCIAL_YEAR'
, PPAA.LEGISLATIVE_PARAMETERS) = PAY_CORE_UTILS.GET_PARAMETER('FINANCIAL_YEAR'
, 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 )

Columns