DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.PAY_AU_SELFP_VALUES_V

Object Details
Object Name: PAY_AU_SELFP_VALUES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPAY.PAY_AU_SELFP_VALUES_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ASSIGNMENT_ROWID ROWID (10)
ASSIGNMENT_ACTION_ID NUMBER (15) Yes
ASSIGNMENT_ID NUMBER (10)
X_REPORTING_FLAG VARCHAR2 (4000)
X_CURR_TERM_0_BAL_FLAG VARCHAR2 (4000)
PAYROLL_ACTION_ID NUMBER (9) Yes
FINANCIAL_YEAR VARCHAR2 (4000)
REGISTERED_EMPLOYER VARCHAR2 (4000)
X_REPORT_END_DATE VARCHAR2 (4000)
X_SUPPLIER_NUMBER VARCHAR2 (4000)
X_SUPPLIER_NAME VARCHAR2 (4000)
X_SUPPLIER_CONTACT_NAME VARCHAR2 (4000)
X_SUPPLIER_CONTACT_TELEPHONE VARCHAR2 (4000)
X_SUPPLIER_ADDRESS_1 VARCHAR2 (4000)
X_SUPPLIER_ADDRESS_2 VARCHAR2 (4000)
X_SUPPLIER_ADDRESS_3 VARCHAR2 (4000)
X_SUPPLIER_SUBURB VARCHAR2 (4000)
X_SUPPLIER_STATE VARCHAR2 (4000)
X_SUPPLIER_POSTCODE VARCHAR2 (4000)
X_SUPPLIER_COUNTRY VARCHAR2 (4000)
X_SUPPLIER_EMAIL VARCHAR2 (4000)
X_EMPLOYER_GROUP_ACT_NO VARCHAR2 (4000)
X_EMPLOYER_BUSINESS_NAME VARCHAR2 (4000)
X_EMPLOYER_TRADING_NAME VARCHAR2 (4000)
X_EMPLOYER_ABN VARCHAR2 (4000)
X_EMPLOYER_CONTACT_NAME VARCHAR2 (4000)
X_EMPLOYER_CONTACT_TELEPHONE VARCHAR2 (4000)
X_EMPLOYER_ADDRESS_1 VARCHAR2 (4000)
X_EMPLOYER_ADDRESS_2 VARCHAR2 (4000)
X_EMPLOYER_ADDRESS_3 VARCHAR2 (4000)
X_EMPLOYER_SUBURB VARCHAR2 (4000)
X_EMPLOYER_STATE VARCHAR2 (4000)
X_EMPLOYER_POSTCODE VARCHAR2 (4000)
X_EMPLOYER_COUNTRY VARCHAR2 (4000)
X_EMPLOYER_BRANCH_NUMBER VARCHAR2 (4000)
X_PAYMENT_SUMMARY_SIGNATORY VARCHAR2 (4000)
X_EMPLOYEE_TAX_FILE_NUMBER VARCHAR2 (4000)
X_EMPLOYEE_FIRST_NAME VARCHAR2 (4000)
X_EMPLOYEE_MIDDLE_NAME VARCHAR2 (4000)
X_EMPLOYEE_SURNAME VARCHAR2 (4000)
X_EMPLOYEE_ABN VARCHAR2 (4000)
X_EMPLOYEE_ADDRESS_1 VARCHAR2 (4000)
X_EMPLOYEE_ADDRESS_2 VARCHAR2 (4000)
X_EMPLOYEE_ADDRESS_3 VARCHAR2 (4000)
X_EMPLOYEE_SUBURB VARCHAR2 (4000)
X_EMPLOYEE_STATE VARCHAR2 (4000)
X_EMPLOYEE_POSTCODE VARCHAR2 (4000)
X_EMPLOYEE_COUNTRY VARCHAR2 (4000)
X_EMPLOYEE_START_DATE VARCHAR2 (4000)
X_EMPLOYEE_END_DATE VARCHAR2 (4000)
X_EMPLOYEE_DATE_OF_BIRTH VARCHAR2 (4000)
X_EMPLOYEE_MANUAL_PS VARCHAR2 (4000)
X_EMPLOYEE_FINAL_PROCESS_DATE VARCHAR2 (4000)
X_UNION_NAMES VARCHAR2 (4000)
X_ETP_TAX_FILE_NUMBER VARCHAR2 (4000)
X_ETP_EMPLOYEE_FIRST_NAME VARCHAR2 (4000)
X_ETP_EMPLOYEE_MIDDLE_NAME VARCHAR2 (4000)
X_ETP_EMPLOYEE_SURNAME VARCHAR2 (4000)
X_ETP_EMPLOYEE_ADDRESS_1 VARCHAR2 (4000)
X_ETP_EMPLOYEE_ADDRESS_2 VARCHAR2 (4000)
X_ETP_EMPLOYEE_ADDRESS_3 VARCHAR2 (4000)
X_ETP_EMPLOYEE_SUBURB VARCHAR2 (4000)
X_ETP_EMPLOYEE_STATE VARCHAR2 (4000)
X_ETP_EMPLOYEE_POSTCODE VARCHAR2 (4000)
X_ETP_EMPLOYEE_COUNTRY VARCHAR2 (4000)
X_ETP_EMPLOYEE_START_DATE VARCHAR2 (4000)
X_ETP_EMPLOYEE_END_DATE VARCHAR2 (4000)
X_ETP_EMPLOYEE_DATE_OF_BIRTH VARCHAR2 (4000)
PAY_DATE VARCHAR2 (4000)
X_EMPLOYEE_LE_END_DATE VARCHAR2 (4000)
X_EMPLOYEE_LE_START_DATE VARCHAR2 (4000)
X_ETP_DEATH_BENEFIT VARCHAR2 (4000)
X_ETP_DEATH_BENEFIT_TYPE VARCHAR2 (4000)
X_TRANSITIONAL_ETP VARCHAR2 (4000)
X_PART_OF_PREVIOUS_ETP VARCHAR2 (4000)
X_ALLOWANCE_1_ASG_YTD VARCHAR2 (4000)
X_ALLOWANCE_2_ASG_YTD VARCHAR2 (4000)
X_ALLOWANCE_3_ASG_YTD VARCHAR2 (4000)
X_ALLOWANCE_4_ASG_YTD VARCHAR2 (4000)
X_ALLOWANCE_1_VALUE VARCHAR2 (4000)
X_ALLOWANCE_2_VALUE VARCHAR2 (4000)
X_ALLOWANCE_3_VALUE VARCHAR2 (4000)
X_ALLOWANCE_4_VALUE VARCHAR2 (4000)
X_ALLOWANCE_5_VALUE VARCHAR2 (4000)
X_ALLOWANCE_6_VALUE VARCHAR2 (4000)
X_ALLOWANCE_7_VALUE VARCHAR2 (4000)
X_ALLOWANCE_8_VALUE VARCHAR2 (4000)
X_ALLOWANCE_9_VALUE VARCHAR2 (4000)
X_ALLOWANCE_10_VALUE VARCHAR2 (4000)
X_ALLOWANCE_11_VALUE VARCHAR2 (4000)
X_ALLOWANCE_12_VALUE VARCHAR2 (4000)
X_ALLOWANCE_13_VALUE VARCHAR2 (4000)
X_ALLOWANCE_14_VALUE VARCHAR2 (4000)
X_ALLOWANCE_15_VALUE VARCHAR2 (4000)
X_ALLOWANCE_16_VALUE VARCHAR2 (4000)
X_ALLOWANCE_17_VALUE VARCHAR2 (4000)
X_ALLOWANCE_18_VALUE VARCHAR2 (4000)
X_ALLOWANCE_19_VALUE VARCHAR2 (4000)
X_ALLOWANCE_20_VALUE VARCHAR2 (4000)
X_ALLOWANCE_21_VALUE VARCHAR2 (4000)
X_ALLOWANCE_22_VALUE VARCHAR2 (4000)
X_ALLOWANCE_23_VALUE VARCHAR2 (4000)
X_ALLOWANCE_24_VALUE VARCHAR2 (4000)
X_ALLOWANCE_25_VALUE VARCHAR2 (4000)
X_ALLOWANCE_26_VALUE VARCHAR2 (4000)
X_ALLOWANCE_27_VALUE VARCHAR2 (4000)
X_ALLOWANCE_28_VALUE VARCHAR2 (4000)
X_ALLOWANCE_29_VALUE VARCHAR2 (4000)
X_ALLOWANCE_30_VALUE VARCHAR2 (4000)
X_UNION_1_VALUE VARCHAR2 (4000)
X_UNION_2_VALUE VARCHAR2 (4000)
X_UNION_3_VALUE VARCHAR2 (4000)
X_UNION_4_VALUE VARCHAR2 (4000)
X_FRINGE_BENEFITS_ASG_YTD VARCHAR2 (4000)
X_CDEP_ASG_YTD VARCHAR2 (4000)
X_EARNINGS_TOTAL_ASG_YTD VARCHAR2 (4000)
X_WORKPLACE_DEDUCTIONS_ASG_YTD VARCHAR2 (4000)
X_LUMP_SUM_A_DEDUCTION_ASG_YTD VARCHAR2 (4000)
X_LUMP_SUM_A_PAYMENTS_ASG_YTD VARCHAR2 (4000)
X_LUMP_SUM_B_DEDUCTION_ASG_YTD VARCHAR2 (4000)
X_LUMP_SUM_B_PAYMENTS_ASG_YTD VARCHAR2 (4000)
X_LUMP_SUM_D_PAYMENTS_ASG_YTD VARCHAR2 (4000)
X_LUMP_SUM_E_PAYMENTS_ASG_YTD VARCHAR2 (4000)
X_TOTAL_TAX_DEDUCTIONS_ASG_YTD NUMBER

X_OTHER_INCOME_ASG_YTD VARCHAR2 (4000)
X_UNION_FEES_ASG_YTD VARCHAR2 (4000)
X_INVALIDITY_PAYMENTS_ASG_YTD VARCHAR2 (4000)
X_LUMP_SUM_C_PAYMENTS_ASG_YTD VARCHAR2 (4000)
X_PRE_JUL_83_COMPONENT_ASG_YTD VARCHAR2 (4000)
X_POST_JUN_83_UNTAXED_ASG_YTD VARCHAR2 (4000)
X_POST_JUN_83_TAXED_ASG_YTD VARCHAR2 (4000)
X_DAYS_PRE_JUL_83 VARCHAR2 (4000)
X_DAYS_POST_JUL_83 VARCHAR2 (4000)
X_PRE_JUL_83_COMP_TRAN_PPT VARCHAR2 (4000)
X_POST_JUN_TAXED_TRAN_PPT VARCHAR2 (4000)
X_PRE_JUL_83_COMP_TRAN_NOPPT VARCHAR2 (4000)
X_POST_JUN_TAXED_TRAN_NOPPT VARCHAR2 (4000)
X_PRE_JUL_83_COMP_NOTRAN_PPT VARCHAR2 (4000)
X_POST_JUN_TAXED_NOTRAN_PPT VARCHAR2 (4000)
X_PRE_JUL_83_COMP_NOTRAN_NOPPT VARCHAR2 (4000)
X_POST_JUN_TAXED_NOTRAN_NOPPT VARCHAR2 (4000)
X_LUMP_SUM_C_DEDUCTION_ASG_YTD VARCHAR2 (4000)
X_ETP_DED_TRAN_PPT VARCHAR2 (4000)
X_ETP_DED_TRAN_NOPPT VARCHAR2 (4000)
X_ETP_DED_NOTRAN_PPT VARCHAR2 (4000)
X_ETP_DED_NOTRAN_NOPPT VARCHAR2 (4000)
X_INV_PAY_TRAN_PPT VARCHAR2 (4000)
X_INV_PAY_TRAN_NOPPT VARCHAR2 (4000)
X_INV_PAY_NOTRAN_PPT VARCHAR2 (4000)
X_INV_PAY_NOTRAN_NOPPT VARCHAR2 (4000)
X_SORT_EMPLOYEE_NUMBER VARCHAR2 (4000)
X_SORT_ASSIGNMENT_LOCATION VARCHAR2 (4000)
X_SORT_PAYROLL VARCHAR2 (4000)
X_SORT_EMPLOYEE_TYPE VARCHAR2 (4000)
X_ETP_ON_TERMINATION_PAID VARCHAR2 (4000)
X_ETP_EMPLOYEE_PAYMENT_DATE VARCHAR2 (4000)
X_ALLOWANCE_NAME_1 VARCHAR2 (4000)
X_ALLOWANCE_NAME_2 VARCHAR2 (4000)
X_ALLOWANCE_NAME_3 VARCHAR2 (4000)
X_ALLOWANCE_NAME_4 VARCHAR2 (4000)
X_ALLOWANCE_1_NAME VARCHAR2 (4000)
X_ALLOWANCE_2_NAME VARCHAR2 (4000)
X_ALLOWANCE_3_NAME VARCHAR2 (4000)
X_ALLOWANCE_4_NAME VARCHAR2 (4000)
X_ALLOWANCE_5_NAME VARCHAR2 (4000)
X_ALLOWANCE_6_NAME VARCHAR2 (4000)
X_ALLOWANCE_7_NAME VARCHAR2 (4000)
X_ALLOWANCE_8_NAME VARCHAR2 (4000)
X_ALLOWANCE_9_NAME VARCHAR2 (4000)
X_ALLOWANCE_10_NAME VARCHAR2 (4000)
X_ALLOWANCE_11_NAME VARCHAR2 (4000)
X_ALLOWANCE_12_NAME VARCHAR2 (4000)
X_ALLOWANCE_13_NAME VARCHAR2 (4000)
X_ALLOWANCE_14_NAME VARCHAR2 (4000)
X_ALLOWANCE_15_NAME VARCHAR2 (4000)
X_ALLOWANCE_16_NAME VARCHAR2 (4000)
X_ALLOWANCE_17_NAME VARCHAR2 (4000)
X_ALLOWANCE_18_NAME VARCHAR2 (4000)
X_ALLOWANCE_19_NAME VARCHAR2 (4000)
X_ALLOWANCE_20_NAME VARCHAR2 (4000)
X_ALLOWANCE_21_NAME VARCHAR2 (4000)
X_ALLOWANCE_22_NAME VARCHAR2 (4000)
X_ALLOWANCE_23_NAME VARCHAR2 (4000)
X_ALLOWANCE_24_NAME VARCHAR2 (4000)
X_ALLOWANCE_25_NAME VARCHAR2 (4000)
X_ALLOWANCE_26_NAME VARCHAR2 (4000)
X_ALLOWANCE_27_NAME VARCHAR2 (4000)
X_ALLOWANCE_28_NAME VARCHAR2 (4000)
X_ALLOWANCE_29_NAME VARCHAR2 (4000)
X_ALLOWANCE_30_NAME VARCHAR2 (4000)
X_UNION_1_NAME VARCHAR2 (4000)
X_UNION_2_NAME VARCHAR2 (4000)
X_UNION_3_NAME VARCHAR2 (4000)
X_UNION_4_NAME VARCHAR2 (4000)
X_PAYMENT_SUMMARY_TYPE VARCHAR2 (4000)
X_PAYG_PAYMENT_SUMMARY_TYPE VARCHAR2 (4000)
X_ETP1_PAYMENT_SUMMARY_TYPE VARCHAR2 (4000)
X_ETP2_PAYMENT_SUMMARY_TYPE VARCHAR2 (4000)
X_ETP3_PAYMENT_SUMMARY_TYPE VARCHAR2 (4000)
X_ETP4_PAYMENT_SUMMARY_TYPE VARCHAR2 (4000)
X_RPT_EMPLOYER_SUPERANN_CONTR VARCHAR2 (4000)
X_EXEMPT_FOREIGN_EMPLOY_INC VARCHAR2 (4000)
X_ETP_DEATH_BENEFIT_TFN VARCHAR2 (4000)
X_LUMP_SUM_A_PAYMENT_TYPE VARCHAR2 (4000)
X_FW1_GROSS_PAYMENTS VARCHAR2 (4000)
X_FW1_CDEP VARCHAR2 (4000)
X_FW1_WORKPLACE_DEDUCTIONS VARCHAR2 (4000)
X_FW1_TOTAL_TAX_WITHHELD VARCHAR2 (4000)
X_FW1_FOREIGN_TAX_PAID VARCHAR2 (4000)
X_FW1_LUMP_SUM_A_PAYMENTS VARCHAR2 (4000)
X_FW1_LUMP_SUM_D_PAYMENTS VARCHAR2 (4000)
X_FW1_LUMP_SUM_E_PAYMENTS VARCHAR2 (4000)
X_FW1_FRINGE_BENEFITS VARCHAR2 (4000)
X_FW1_RPT_EMPER_SUPER_CONTR VARCHAR2 (4000)
X_FW2_GROSS_PAYMENTS VARCHAR2 (4000)
X_FW2_TOTAL_TAX_WITHHELD VARCHAR2 (4000)
X_FW2_FOREIGN_TAX_PAID VARCHAR2 (4000)
X_FW2_CDEP VARCHAR2 (4000)
X_FW2_LUMP_SUM_A_PAYMENTS VARCHAR2 (4000)
X_FW2_LUMP_SUM_D_PAYMENTS VARCHAR2 (4000)
X_FW2_LUMP_SUM_E_PAYMENTS VARCHAR2 (4000)
X_FW2_FRINGE_BENEFITS VARCHAR2 (4000)
X_FW2_RPT_EMPER_SUPER_CONTR VARCHAR2 (4000)
X_FW2_WORKPLACE_DEDUCTIONS VARCHAR2 (4000)
X_FW1_UNION_1_VALUE VARCHAR2 (4000)
X_FW1_UNION_2_VALUE VARCHAR2 (4000)
X_FW1_UNION_3_VALUE VARCHAR2 (4000)
X_FW1_UNION_4_VALUE VARCHAR2 (4000)
X_FW2_UNION_1_VALUE VARCHAR2 (4000)
X_FW2_UNION_2_VALUE VARCHAR2 (4000)
X_FW2_UNION_3_VALUE VARCHAR2 (4000)
X_FW2_UNION_4_VALUE VARCHAR2 (4000)
X_FW1_PAYMENT_SUMMARY_TYPE VARCHAR2 (4000)
X_FW1_GROSS_PAYMENT_TYPE VARCHAR2 (4000)
X_FW1_START_DATE VARCHAR2 (4000)
X_FW1_END_DATE VARCHAR2 (4000)
X_FW2_PAYMENT_SUMMARY_TYPE VARCHAR2 (4000)
X_FW2_GROSS_PAYMENT_TYPE VARCHAR2 (4000)
X_FW2_START_DATE VARCHAR2 (4000)
X_FW2_END_DATE VARCHAR2 (4000)
X_FW1_ALLOWANCE_CONCAT1 VARCHAR2 (4000)
X_FW1_ALLOWANCE_CONCAT2 VARCHAR2 (4000)
X_FW1_ALLOWANCE_CONCAT3 VARCHAR2 (4000)
X_FW1_ALLOWANCE_CONCAT4 VARCHAR2 (4000)
X_FW1_ALLOWANCE_CONCAT5 VARCHAR2 (4000)
X_FW2_ALLOWANCE_CONCAT1 VARCHAR2 (4000)
X_FW2_ALLOWANCE_CONCAT2 VARCHAR2 (4000)
X_FW2_ALLOWANCE_CONCAT3 VARCHAR2 (4000)
X_FW2_ALLOWANCE_CONCAT4 VARCHAR2 (4000)
X_FW2_ALLOWANCE_CONCAT5 VARCHAR2 (4000)
X_FW1_UNION_1_NAME VARCHAR2 (4000)
X_FW1_UNION_2_NAME VARCHAR2 (4000)
X_FW1_UNION_3_NAME VARCHAR2 (4000)
X_FW1_UNION_4_NAME VARCHAR2 (4000)
X_FW2_UNION_1_NAME VARCHAR2 (4000)
X_FW2_UNION_2_NAME VARCHAR2 (4000)
X_FW2_UNION_3_NAME VARCHAR2 (4000)
X_FW2_UNION_4_NAME VARCHAR2 (4000)
X_FW_PAYG_TYPE VARCHAR2 (4000)
X_ETP_DED_EXCL_ASG_YTD VARCHAR2 (4000)
X_ETP_DED_EXCL_PP_ASG_YTD VARCHAR2 (4000)
X_ETP_DED_NON_EXCL_ASG_YTD VARCHAR2 (4000)
X_ETP_DED_NON_EXCL_PP_ASG_YTD VARCHAR2 (4000)
X_PRE_JUL_83_EXCL_ASG_YTD VARCHAR2 (4000)
X_INV_PAY_EXCL_ASG_YTD VARCHAR2 (4000)
X_PRE_JUL_83_EXCL_PP_ASG_YTD VARCHAR2 (4000)
X_INV_PAY_EXCL_PP_ASG_YTD VARCHAR2 (4000)
X_PRE_JUL_83_NE_ASG_YTD VARCHAR2 (4000)
X_PRE_JUL_83_NE_PP_ASG_YTD VARCHAR2 (4000)
X_POST_JUN_83_EXCL_ASG_YTD VARCHAR2 (4000)
X_POST_JUN_83_EXCL_PP_ASG_YTD VARCHAR2 (4000)
X_POST_JUN_83_NE_ASG_YTD VARCHAR2 (4000)
X_POST_JUN_83_NE_PP_ASG_YTD VARCHAR2 (4000)
X_ETP_EXCL_PAYMENT_DATE_1 VARCHAR2 (4000)
X_ETP_EXCL_PAID_1 VARCHAR2 (4000)
X_ETP_DED_EXCL_1 VARCHAR2 (4000)
X_POST_JUN_83_TAXED_EXCL_1 VARCHAR2 (4000)
X_PRE_JUL_83_COMP_EXCL_1 VARCHAR2 (4000)
X_ETP_EXCL_PAYMENT_DATE_2 VARCHAR2 (4000)
X_ETP_EXCL_PAID_2 VARCHAR2 (4000)
X_ETP_DED_EXCL_2 VARCHAR2 (4000)
X_POST_JUN_83_TAXED_EXCL_2 VARCHAR2 (4000)
X_PRE_JUL_83_COMP_EXCL_2 VARCHAR2 (4000)
X_ETP_EXCL_PAYMENT_DATE_3 VARCHAR2 (4000)
X_ETP_EXCL_PAID_3 VARCHAR2 (4000)
X_ETP_DED_EXCL_3 VARCHAR2 (4000)
X_POST_JUN_83_TAXED_EXCL_3 VARCHAR2 (4000)
X_PRE_JUL_83_COMP_EXCL_3 VARCHAR2 (4000)
X_ETP_EXCL_PAYMENT_DATE_4 VARCHAR2 (4000)
X_ETP_EXCL_PAID_4 VARCHAR2 (4000)
X_ETP_DED_EXCL_4 VARCHAR2 (4000)
X_POST_JUN_83_TAXED_EXCL_4 VARCHAR2 (4000)
X_PRE_JUL_83_COMP_EXCL_4 VARCHAR2 (4000)
X_ETP_EXCL_PAYMENT_DATE_5 VARCHAR2 (4000)
X_ETP_EXCL_PAID_5 VARCHAR2 (4000)
X_ETP_DED_EXCL_5 VARCHAR2 (4000)
X_POST_JUN_83_TAXED_EXCL_5 VARCHAR2 (4000)
X_PRE_JUL_83_COMP_EXCL_5 VARCHAR2 (4000)
X_ETP_EXCL_PP_PAYMENT_DATE_1 VARCHAR2 (4000)
X_ETP_EXCL_PP_PAID_1 VARCHAR2 (4000)
X_ETP_DED_EXCL_PP_1 VARCHAR2 (4000)
X_POST_JUN_83_TAXED_EXCL_PP_1 VARCHAR2 (4000)
X_PRE_JUL_83_COMP_EXCL_PP_1 VARCHAR2 (4000)
X_ETP_EXCL_PP_PAYMENT_DATE_2 VARCHAR2 (4000)
X_ETP_EXCL_PP_PAID_2 VARCHAR2 (4000)
X_ETP_DED_EXCL_PP_2 VARCHAR2 (4000)
X_POST_JUN_83_TAXED_EXCL_PP_2 VARCHAR2 (4000)
X_PRE_JUL_83_COMP_EXCL_PP_2 VARCHAR2 (4000)
X_ETP_EXCL_PP_PAYMENT_DATE_3 VARCHAR2 (4000)
X_ETP_EXCL_PP_PAID_3 VARCHAR2 (4000)
X_ETP_DED_EXCL_PP_3 VARCHAR2 (4000)
X_POST_JUN_83_TAXED_EXCL_PP_3 VARCHAR2 (4000)
X_PRE_JUL_83_COMP_EXCL_PP_3 VARCHAR2 (4000)
X_ETP_EXCL_PP_PAYMENT_DATE_4 VARCHAR2 (4000)
X_ETP_EXCL_PP_PAID_4 VARCHAR2 (4000)
X_ETP_DED_EXCL_PP_4 VARCHAR2 (4000)
X_POST_JUN_83_TAXED_EXCL_PP_4 VARCHAR2 (4000)
X_PRE_JUL_83_COMP_EXCL_PP_4 VARCHAR2 (4000)
X_ETP_EXCL_PP_PAYMENT_DATE_5 VARCHAR2 (4000)
X_ETP_EXCL_PP_PAID_5 VARCHAR2 (4000)
X_ETP_DED_EXCL_PP_5 VARCHAR2 (4000)
X_POST_JUN_83_TAXED_EXCL_PP_5 VARCHAR2 (4000)
X_PRE_JUL_83_COMP_EXCL_PP_5 VARCHAR2 (4000)
X_ETP_NE_PAYMENT_DATE_1 VARCHAR2 (4000)
X_ETP_NE_PAID_1 VARCHAR2 (4000)
X_ETP_DED_NE_1 VARCHAR2 (4000)
X_POST_JUN_83_TAXED_NE_1 VARCHAR2 (4000)
X_PRE_JUL_83_COMP_NE_1 VARCHAR2 (4000)
X_ETP_NE_PAYMENT_DATE_2 VARCHAR2 (4000)
X_ETP_NE_PAID_2 VARCHAR2 (4000)
X_ETP_DED_NE_2 VARCHAR2 (4000)
X_POST_JUN_83_TAXED_NE_2 VARCHAR2 (4000)
X_PRE_JUL_83_COMP_NE_2 VARCHAR2 (4000)
X_ETP_NE_PAYMENT_DATE_3 VARCHAR2 (4000)
X_ETP_NE_PAID_3 VARCHAR2 (4000)
X_ETP_DED_NE_3 VARCHAR2 (4000)
X_POST_JUN_83_TAXED_NE_3 VARCHAR2 (4000)
X_PRE_JUL_83_COMP_NE_3 VARCHAR2 (4000)
X_ETP_NE_PAYMENT_DATE_4 VARCHAR2 (4000)
X_ETP_NE_PAID_4 VARCHAR2 (4000)
X_ETP_DED_NE_4 VARCHAR2 (4000)
X_POST_JUN_83_TAXED_NE_4 VARCHAR2 (4000)
X_PRE_JUL_83_COMP_NE_4 VARCHAR2 (4000)
X_ETP_NE_PAYMENT_DATE_5 VARCHAR2 (4000)
X_ETP_NE_PAID_5 VARCHAR2 (4000)
X_ETP_DED_NE_5 VARCHAR2 (4000)
X_POST_JUN_83_TAXED_NE_5 VARCHAR2 (4000)
X_PRE_JUL_83_COMP_NE_5 VARCHAR2 (4000)
X_ETP_NE_PP_PAYMENT_DATE_1 VARCHAR2 (4000)
X_ETP_NE_PP_PAID_1 VARCHAR2 (4000)
X_ETP_DED_NE_PP_1 VARCHAR2 (4000)
X_POST_JUN_83_TAXED_NE_PP_1 VARCHAR2 (4000)
X_PRE_JUL_83_COMP_NE_PP_1 VARCHAR2 (4000)
X_ETP_NE_PP_PAYMENT_DATE_2 VARCHAR2 (4000)
X_ETP_NE_PP_PAID_2 VARCHAR2 (4000)
X_ETP_DED_NE_PP_2 VARCHAR2 (4000)
X_POST_JUN_83_TAXED_NE_PP_2 VARCHAR2 (4000)
X_PRE_JUL_83_COMP_NE_PP_2 VARCHAR2 (4000)
X_ETP_NE_PP_PAYMENT_DATE_3 VARCHAR2 (4000)
X_ETP_NE_PP_PAID_3 VARCHAR2 (4000)
X_ETP_DED_NE_PP_3 VARCHAR2 (4000)
X_POST_JUN_83_TAXED_NE_PP_3 VARCHAR2 (4000)
X_PRE_JUL_83_COMP_NE_PP_3 VARCHAR2 (4000)
X_ETP_NE_PP_PAYMENT_DATE_4 VARCHAR2 (4000)
X_ETP_NE_PP_PAID_4 VARCHAR2 (4000)
X_ETP_DED_NE_PP_4 VARCHAR2 (4000)
X_POST_JUN_83_TAXED_NE_PP_4 VARCHAR2 (4000)
X_PRE_JUL_83_COMP_NE_PP_4 VARCHAR2 (4000)
X_ETP_NE_PP_PAYMENT_DATE_5 VARCHAR2 (4000)
X_ETP_NE_PP_PAID_5 VARCHAR2 (4000)
X_ETP_DED_NE_PP_5 VARCHAR2 (4000)
X_POST_JUN_83_TAXED_NE_PP_5 VARCHAR2 (4000)
X_PRE_JUL_83_COMP_NE_PP_5 VARCHAR2 (4000)
X_INV_PAY_EXCL_1 VARCHAR2 (4000)
X_INV_PAY_EXCL_2 VARCHAR2 (4000)
X_INV_PAY_EXCL_3 VARCHAR2 (4000)
X_INV_PAY_EXCL_4 VARCHAR2 (4000)
X_INV_PAY_EXCL_5 VARCHAR2 (4000)
X_INV_PAY_EXCL_PP_1 VARCHAR2 (4000)
X_INV_PAY_EXCL_PP_2 VARCHAR2 (4000)
X_INV_PAY_EXCL_PP_3 VARCHAR2 (4000)
X_INV_PAY_EXCL_PP_4 VARCHAR2 (4000)
X_INV_PAY_EXCL_PP_5 VARCHAR2 (4000)
REPORT_TYPE VARCHAR2 (30)
ASSIGNMENT_NUMBER VARCHAR2 (30)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ASSIGNMENT_ROWID
,      ASSIGNMENT_ACTION_ID
,      ASSIGNMENT_ID
,      X_REPORTING_FLAG
,      X_CURR_TERM_0_BAL_FLAG
,      PAYROLL_ACTION_ID
,      FINANCIAL_YEAR
,      REGISTERED_EMPLOYER
,      X_REPORT_END_DATE
,      X_SUPPLIER_NUMBER
,      X_SUPPLIER_NAME
,      X_SUPPLIER_CONTACT_NAME
,      X_SUPPLIER_CONTACT_TELEPHONE
,      X_SUPPLIER_ADDRESS_1
,      X_SUPPLIER_ADDRESS_2
,      X_SUPPLIER_ADDRESS_3
,      X_SUPPLIER_SUBURB
,      X_SUPPLIER_STATE
,      X_SUPPLIER_POSTCODE
,      X_SUPPLIER_COUNTRY
,      X_SUPPLIER_EMAIL
,      X_EMPLOYER_GROUP_ACT_NO
,      X_EMPLOYER_BUSINESS_NAME
,      X_EMPLOYER_TRADING_NAME
,      X_EMPLOYER_ABN
,      X_EMPLOYER_CONTACT_NAME
,      X_EMPLOYER_CONTACT_TELEPHONE
,      X_EMPLOYER_ADDRESS_1
,      X_EMPLOYER_ADDRESS_2
,      X_EMPLOYER_ADDRESS_3
,      X_EMPLOYER_SUBURB
,      X_EMPLOYER_STATE
,      X_EMPLOYER_POSTCODE
,      X_EMPLOYER_COUNTRY
,      X_EMPLOYER_BRANCH_NUMBER
,      X_PAYMENT_SUMMARY_SIGNATORY
,      X_EMPLOYEE_TAX_FILE_NUMBER
,      X_EMPLOYEE_FIRST_NAME
,      X_EMPLOYEE_MIDDLE_NAME
,      X_EMPLOYEE_SURNAME
,      X_EMPLOYEE_ABN
,      X_EMPLOYEE_ADDRESS_1
,      X_EMPLOYEE_ADDRESS_2
,      X_EMPLOYEE_ADDRESS_3
,      X_EMPLOYEE_SUBURB
,      X_EMPLOYEE_STATE
,      X_EMPLOYEE_POSTCODE
,      X_EMPLOYEE_COUNTRY
,      X_EMPLOYEE_START_DATE
,      X_EMPLOYEE_END_DATE
,      X_EMPLOYEE_DATE_OF_BIRTH
,      X_EMPLOYEE_MANUAL_PS
,      X_EMPLOYEE_FINAL_PROCESS_DATE
,      X_UNION_NAMES
,      X_ETP_TAX_FILE_NUMBER
,      X_ETP_EMPLOYEE_FIRST_NAME
,      X_ETP_EMPLOYEE_MIDDLE_NAME
,      X_ETP_EMPLOYEE_SURNAME
,      X_ETP_EMPLOYEE_ADDRESS_1
,      X_ETP_EMPLOYEE_ADDRESS_2
,      X_ETP_EMPLOYEE_ADDRESS_3
,      X_ETP_EMPLOYEE_SUBURB
,      X_ETP_EMPLOYEE_STATE
,      X_ETP_EMPLOYEE_POSTCODE
,      X_ETP_EMPLOYEE_COUNTRY
,      X_ETP_EMPLOYEE_START_DATE
,      X_ETP_EMPLOYEE_END_DATE
,      X_ETP_EMPLOYEE_DATE_OF_BIRTH
,      PAY_DATE
,      X_EMPLOYEE_LE_END_DATE
,      X_EMPLOYEE_LE_START_DATE
,      X_ETP_DEATH_BENEFIT
,      X_ETP_DEATH_BENEFIT_TYPE
,      X_TRANSITIONAL_ETP
,      X_PART_OF_PREVIOUS_ETP
,      X_ALLOWANCE_1_ASG_YTD
,      X_ALLOWANCE_2_ASG_YTD
,      X_ALLOWANCE_3_ASG_YTD
,      X_ALLOWANCE_4_ASG_YTD
,      X_ALLOWANCE_1_VALUE
,      X_ALLOWANCE_2_VALUE
,      X_ALLOWANCE_3_VALUE
,      X_ALLOWANCE_4_VALUE
,      X_ALLOWANCE_5_VALUE
,      X_ALLOWANCE_6_VALUE
,      X_ALLOWANCE_7_VALUE
,      X_ALLOWANCE_8_VALUE
,      X_ALLOWANCE_9_VALUE
,      X_ALLOWANCE_10_VALUE
,      X_ALLOWANCE_11_VALUE
,      X_ALLOWANCE_12_VALUE
,      X_ALLOWANCE_13_VALUE
,      X_ALLOWANCE_14_VALUE
,      X_ALLOWANCE_15_VALUE
,      X_ALLOWANCE_16_VALUE
,      X_ALLOWANCE_17_VALUE
,      X_ALLOWANCE_18_VALUE
,      X_ALLOWANCE_19_VALUE
,      X_ALLOWANCE_20_VALUE
,      X_ALLOWANCE_21_VALUE
,      X_ALLOWANCE_22_VALUE
,      X_ALLOWANCE_23_VALUE
,      X_ALLOWANCE_24_VALUE
,      X_ALLOWANCE_25_VALUE
,      X_ALLOWANCE_26_VALUE
,      X_ALLOWANCE_27_VALUE
,      X_ALLOWANCE_28_VALUE
,      X_ALLOWANCE_29_VALUE
,      X_ALLOWANCE_30_VALUE
,      X_UNION_1_VALUE
,      X_UNION_2_VALUE
,      X_UNION_3_VALUE
,      X_UNION_4_VALUE
,      X_FRINGE_BENEFITS_ASG_YTD
,      X_CDEP_ASG_YTD
,      X_EARNINGS_TOTAL_ASG_YTD
,      X_WORKPLACE_DEDUCTIONS_ASG_YTD
,      X_LUMP_SUM_A_DEDUCTION_ASG_YTD
,      X_LUMP_SUM_A_PAYMENTS_ASG_YTD
,      X_LUMP_SUM_B_DEDUCTION_ASG_YTD
,      X_LUMP_SUM_B_PAYMENTS_ASG_YTD
,      X_LUMP_SUM_D_PAYMENTS_ASG_YTD
,      X_LUMP_SUM_E_PAYMENTS_ASG_YTD
,      X_TOTAL_TAX_DEDUCTIONS_ASG_YTD
,      X_OTHER_INCOME_ASG_YTD
,      X_UNION_FEES_ASG_YTD
,      X_INVALIDITY_PAYMENTS_ASG_YTD
,      X_LUMP_SUM_C_PAYMENTS_ASG_YTD
,      X_PRE_JUL_83_COMPONENT_ASG_YTD
,      X_POST_JUN_83_UNTAXED_ASG_YTD
,      X_POST_JUN_83_TAXED_ASG_YTD
,      X_DAYS_PRE_JUL_83
,      X_DAYS_POST_JUL_83
,      X_PRE_JUL_83_COMP_TRAN_PPT
,      X_POST_JUN_TAXED_TRAN_PPT
,      X_PRE_JUL_83_COMP_TRAN_NOPPT
,      X_POST_JUN_TAXED_TRAN_NOPPT
,      X_PRE_JUL_83_COMP_NOTRAN_PPT
,      X_POST_JUN_TAXED_NOTRAN_PPT
,      X_PRE_JUL_83_COMP_NOTRAN_NOPPT
,      X_POST_JUN_TAXED_NOTRAN_NOPPT
,      X_LUMP_SUM_C_DEDUCTION_ASG_YTD
,      X_ETP_DED_TRAN_PPT
,      X_ETP_DED_TRAN_NOPPT
,      X_ETP_DED_NOTRAN_PPT
,      X_ETP_DED_NOTRAN_NOPPT
,      X_INV_PAY_TRAN_PPT
,      X_INV_PAY_TRAN_NOPPT
,      X_INV_PAY_NOTRAN_PPT
,      X_INV_PAY_NOTRAN_NOPPT
,      X_SORT_EMPLOYEE_NUMBER
,      X_SORT_ASSIGNMENT_LOCATION
,      X_SORT_PAYROLL
,      X_SORT_EMPLOYEE_TYPE
,      X_ETP_ON_TERMINATION_PAID
,      X_ETP_EMPLOYEE_PAYMENT_DATE
,      X_ALLOWANCE_NAME_1
,      X_ALLOWANCE_NAME_2
,      X_ALLOWANCE_NAME_3
,      X_ALLOWANCE_NAME_4
,      X_ALLOWANCE_1_NAME
,      X_ALLOWANCE_2_NAME
,      X_ALLOWANCE_3_NAME
,      X_ALLOWANCE_4_NAME
,      X_ALLOWANCE_5_NAME
,      X_ALLOWANCE_6_NAME
,      X_ALLOWANCE_7_NAME
,      X_ALLOWANCE_8_NAME
,      X_ALLOWANCE_9_NAME
,      X_ALLOWANCE_10_NAME
,      X_ALLOWANCE_11_NAME
,      X_ALLOWANCE_12_NAME
,      X_ALLOWANCE_13_NAME
,      X_ALLOWANCE_14_NAME
,      X_ALLOWANCE_15_NAME
,      X_ALLOWANCE_16_NAME
,      X_ALLOWANCE_17_NAME
,      X_ALLOWANCE_18_NAME
,      X_ALLOWANCE_19_NAME
,      X_ALLOWANCE_20_NAME
,      X_ALLOWANCE_21_NAME
,      X_ALLOWANCE_22_NAME
,      X_ALLOWANCE_23_NAME
,      X_ALLOWANCE_24_NAME
,      X_ALLOWANCE_25_NAME
,      X_ALLOWANCE_26_NAME
,      X_ALLOWANCE_27_NAME
,      X_ALLOWANCE_28_NAME
,      X_ALLOWANCE_29_NAME
,      X_ALLOWANCE_30_NAME
,      X_UNION_1_NAME
,      X_UNION_2_NAME
,      X_UNION_3_NAME
,      X_UNION_4_NAME
,      X_PAYMENT_SUMMARY_TYPE
,      X_PAYG_PAYMENT_SUMMARY_TYPE
,      X_ETP1_PAYMENT_SUMMARY_TYPE
,      X_ETP2_PAYMENT_SUMMARY_TYPE
,      X_ETP3_PAYMENT_SUMMARY_TYPE
,      X_ETP4_PAYMENT_SUMMARY_TYPE
,      X_RPT_EMPLOYER_SUPERANN_CONTR
,      X_EXEMPT_FOREIGN_EMPLOY_INC
,      X_ETP_DEATH_BENEFIT_TFN
,      X_LUMP_SUM_A_PAYMENT_TYPE
,      X_FW1_GROSS_PAYMENTS
,      X_FW1_CDEP
,      X_FW1_WORKPLACE_DEDUCTIONS
,      X_FW1_TOTAL_TAX_WITHHELD
,      X_FW1_FOREIGN_TAX_PAID
,      X_FW1_LUMP_SUM_A_PAYMENTS
,      X_FW1_LUMP_SUM_D_PAYMENTS
,      X_FW1_LUMP_SUM_E_PAYMENTS
,      X_FW1_FRINGE_BENEFITS
,      X_FW1_RPT_EMPER_SUPER_CONTR
,      X_FW2_GROSS_PAYMENTS
,      X_FW2_TOTAL_TAX_WITHHELD
,      X_FW2_FOREIGN_TAX_PAID
,      X_FW2_CDEP
,      X_FW2_LUMP_SUM_A_PAYMENTS
,      X_FW2_LUMP_SUM_D_PAYMENTS
,      X_FW2_LUMP_SUM_E_PAYMENTS
,      X_FW2_FRINGE_BENEFITS
,      X_FW2_RPT_EMPER_SUPER_CONTR
,      X_FW2_WORKPLACE_DEDUCTIONS
,      X_FW1_UNION_1_VALUE
,      X_FW1_UNION_2_VALUE
,      X_FW1_UNION_3_VALUE
,      X_FW1_UNION_4_VALUE
,      X_FW2_UNION_1_VALUE
,      X_FW2_UNION_2_VALUE
,      X_FW2_UNION_3_VALUE
,      X_FW2_UNION_4_VALUE
,      X_FW1_PAYMENT_SUMMARY_TYPE
,      X_FW1_GROSS_PAYMENT_TYPE
,      X_FW1_START_DATE
,      X_FW1_END_DATE
,      X_FW2_PAYMENT_SUMMARY_TYPE
,      X_FW2_GROSS_PAYMENT_TYPE
,      X_FW2_START_DATE
,      X_FW2_END_DATE
,      X_FW1_ALLOWANCE_CONCAT1
,      X_FW1_ALLOWANCE_CONCAT2
,      X_FW1_ALLOWANCE_CONCAT3
,      X_FW1_ALLOWANCE_CONCAT4
,      X_FW1_ALLOWANCE_CONCAT5
,      X_FW2_ALLOWANCE_CONCAT1
,      X_FW2_ALLOWANCE_CONCAT2
,      X_FW2_ALLOWANCE_CONCAT3
,      X_FW2_ALLOWANCE_CONCAT4
,      X_FW2_ALLOWANCE_CONCAT5
,      X_FW1_UNION_1_NAME
,      X_FW1_UNION_2_NAME
,      X_FW1_UNION_3_NAME
,      X_FW1_UNION_4_NAME
,      X_FW2_UNION_1_NAME
,      X_FW2_UNION_2_NAME
,      X_FW2_UNION_3_NAME
,      X_FW2_UNION_4_NAME
,      X_FW_PAYG_TYPE
,      X_ETP_DED_EXCL_ASG_YTD
,      X_ETP_DED_EXCL_PP_ASG_YTD
,      X_ETP_DED_NON_EXCL_ASG_YTD
,      X_ETP_DED_NON_EXCL_PP_ASG_YTD
,      X_PRE_JUL_83_EXCL_ASG_YTD
,      X_INV_PAY_EXCL_ASG_YTD
,      X_PRE_JUL_83_EXCL_PP_ASG_YTD
,      X_INV_PAY_EXCL_PP_ASG_YTD
,      X_PRE_JUL_83_NE_ASG_YTD
,      X_PRE_JUL_83_NE_PP_ASG_YTD
,      X_POST_JUN_83_EXCL_ASG_YTD
,      X_POST_JUN_83_EXCL_PP_ASG_YTD
,      X_POST_JUN_83_NE_ASG_YTD
,      X_POST_JUN_83_NE_PP_ASG_YTD
,      X_ETP_EXCL_PAYMENT_DATE_1
,      X_ETP_EXCL_PAID_1
,      X_ETP_DED_EXCL_1
,      X_POST_JUN_83_TAXED_EXCL_1
,      X_PRE_JUL_83_COMP_EXCL_1
,      X_ETP_EXCL_PAYMENT_DATE_2
,      X_ETP_EXCL_PAID_2
,      X_ETP_DED_EXCL_2
,      X_POST_JUN_83_TAXED_EXCL_2
,      X_PRE_JUL_83_COMP_EXCL_2
,      X_ETP_EXCL_PAYMENT_DATE_3
,      X_ETP_EXCL_PAID_3
,      X_ETP_DED_EXCL_3
,      X_POST_JUN_83_TAXED_EXCL_3
,      X_PRE_JUL_83_COMP_EXCL_3
,      X_ETP_EXCL_PAYMENT_DATE_4
,      X_ETP_EXCL_PAID_4
,      X_ETP_DED_EXCL_4
,      X_POST_JUN_83_TAXED_EXCL_4
,      X_PRE_JUL_83_COMP_EXCL_4
,      X_ETP_EXCL_PAYMENT_DATE_5
,      X_ETP_EXCL_PAID_5
,      X_ETP_DED_EXCL_5
,      X_POST_JUN_83_TAXED_EXCL_5
,      X_PRE_JUL_83_COMP_EXCL_5
,      X_ETP_EXCL_PP_PAYMENT_DATE_1
,      X_ETP_EXCL_PP_PAID_1
,      X_ETP_DED_EXCL_PP_1
,      X_POST_JUN_83_TAXED_EXCL_PP_1
,      X_PRE_JUL_83_COMP_EXCL_PP_1
,      X_ETP_EXCL_PP_PAYMENT_DATE_2
,      X_ETP_EXCL_PP_PAID_2
,      X_ETP_DED_EXCL_PP_2
,      X_POST_JUN_83_TAXED_EXCL_PP_2
,      X_PRE_JUL_83_COMP_EXCL_PP_2
,      X_ETP_EXCL_PP_PAYMENT_DATE_3
,      X_ETP_EXCL_PP_PAID_3
,      X_ETP_DED_EXCL_PP_3
,      X_POST_JUN_83_TAXED_EXCL_PP_3
,      X_PRE_JUL_83_COMP_EXCL_PP_3
,      X_ETP_EXCL_PP_PAYMENT_DATE_4
,      X_ETP_EXCL_PP_PAID_4
,      X_ETP_DED_EXCL_PP_4
,      X_POST_JUN_83_TAXED_EXCL_PP_4
,      X_PRE_JUL_83_COMP_EXCL_PP_4
,      X_ETP_EXCL_PP_PAYMENT_DATE_5
,      X_ETP_EXCL_PP_PAID_5
,      X_ETP_DED_EXCL_PP_5
,      X_POST_JUN_83_TAXED_EXCL_PP_5
,      X_PRE_JUL_83_COMP_EXCL_PP_5
,      X_ETP_NE_PAYMENT_DATE_1
,      X_ETP_NE_PAID_1
,      X_ETP_DED_NE_1
,      X_POST_JUN_83_TAXED_NE_1
,      X_PRE_JUL_83_COMP_NE_1
,      X_ETP_NE_PAYMENT_DATE_2
,      X_ETP_NE_PAID_2
,      X_ETP_DED_NE_2
,      X_POST_JUN_83_TAXED_NE_2
,      X_PRE_JUL_83_COMP_NE_2
,      X_ETP_NE_PAYMENT_DATE_3
,      X_ETP_NE_PAID_3
,      X_ETP_DED_NE_3
,      X_POST_JUN_83_TAXED_NE_3
,      X_PRE_JUL_83_COMP_NE_3
,      X_ETP_NE_PAYMENT_DATE_4
,      X_ETP_NE_PAID_4
,      X_ETP_DED_NE_4
,      X_POST_JUN_83_TAXED_NE_4
,      X_PRE_JUL_83_COMP_NE_4
,      X_ETP_NE_PAYMENT_DATE_5
,      X_ETP_NE_PAID_5
,      X_ETP_DED_NE_5
,      X_POST_JUN_83_TAXED_NE_5
,      X_PRE_JUL_83_COMP_NE_5
,      X_ETP_NE_PP_PAYMENT_DATE_1
,      X_ETP_NE_PP_PAID_1
,      X_ETP_DED_NE_PP_1
,      X_POST_JUN_83_TAXED_NE_PP_1
,      X_PRE_JUL_83_COMP_NE_PP_1
,      X_ETP_NE_PP_PAYMENT_DATE_2
,      X_ETP_NE_PP_PAID_2
,      X_ETP_DED_NE_PP_2
,      X_POST_JUN_83_TAXED_NE_PP_2
,      X_PRE_JUL_83_COMP_NE_PP_2
,      X_ETP_NE_PP_PAYMENT_DATE_3
,      X_ETP_NE_PP_PAID_3
,      X_ETP_DED_NE_PP_3
,      X_POST_JUN_83_TAXED_NE_PP_3
,      X_PRE_JUL_83_COMP_NE_PP_3
,      X_ETP_NE_PP_PAYMENT_DATE_4
,      X_ETP_NE_PP_PAID_4
,      X_ETP_DED_NE_PP_4
,      X_POST_JUN_83_TAXED_NE_PP_4
,      X_PRE_JUL_83_COMP_NE_PP_4
,      X_ETP_NE_PP_PAYMENT_DATE_5
,      X_ETP_NE_PP_PAID_5
,      X_ETP_DED_NE_PP_5
,      X_POST_JUN_83_TAXED_NE_PP_5
,      X_PRE_JUL_83_COMP_NE_PP_5
,      X_INV_PAY_EXCL_1
,      X_INV_PAY_EXCL_2
,      X_INV_PAY_EXCL_3
,      X_INV_PAY_EXCL_4
,      X_INV_PAY_EXCL_5
,      X_INV_PAY_EXCL_PP_1
,      X_INV_PAY_EXCL_PP_2
,      X_INV_PAY_EXCL_PP_3
,      X_INV_PAY_EXCL_PP_4
,      X_INV_PAY_EXCL_PP_5
,      REPORT_TYPE
,      ASSIGNMENT_NUMBER
FROM APPS.PAY_AU_SELFP_VALUES_V;

Dependencies

[top of page]

APPS.PAY_AU_SELFP_VALUES_V references the following:

SchemaAPPS
SynonymPAY_ACTION_INTERLOCKS
SynonymPAY_ASSIGNMENT_ACTIONS
PL/SQL PackagePAY_AU_PAYMENT_SUMMARY - show dependent code
PL/SQL PackagePAY_CORE_UTILS - show dependent code
SynonymPAY_PAYROLL_ACTIONS
SynonymPER_ALL_ASSIGNMENTS_F

APPS.PAY_AU_SELFP_VALUES_V is not referenced by any database object