[Home] [Help] [Dependency Information]

VIEW: APPS.PAY_AU_EOY_VALUES_V

Object Details

Object Name:	PAY_AU_EOY_VALUES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PAY.PAY_AU_EOY_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

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_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_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_1_VALUE
,      X_ALLOWANCE_2_NAME
,      X_ALLOWANCE_2_VALUE
,      X_ALLOWANCE_3_NAME
,      X_ALLOWANCE_3_VALUE
,      X_ALLOWANCE_4_NAME
,      X_ALLOWANCE_4_VALUE
,      X_ALLOWANCE_5_NAME
,      X_ALLOWANCE_5_VALUE
,      X_ALLOWANCE_6_NAME
,      X_ALLOWANCE_6_VALUE
,      X_ALLOWANCE_7_NAME
,      X_ALLOWANCE_7_VALUE
,      X_ALLOWANCE_8_NAME
,      X_ALLOWANCE_8_VALUE
,      X_ALLOWANCE_9_NAME
,      X_ALLOWANCE_9_VALUE
,      X_ALLOWANCE_10_NAME
,      X_ALLOWANCE_10_VALUE
,      X_ALLOWANCE_11_NAME
,      X_ALLOWANCE_11_VALUE
,      X_ALLOWANCE_12_NAME
,      X_ALLOWANCE_12_VALUE
,      X_ALLOWANCE_13_NAME
,      X_ALLOWANCE_13_VALUE
,      X_ALLOWANCE_14_NAME
,      X_ALLOWANCE_14_VALUE
,      X_ALLOWANCE_15_NAME
,      X_ALLOWANCE_15_VALUE
,      X_ALLOWANCE_16_NAME
,      X_ALLOWANCE_16_VALUE
,      X_ALLOWANCE_17_NAME
,      X_ALLOWANCE_17_VALUE
,      X_ALLOWANCE_18_NAME
,      X_ALLOWANCE_18_VALUE
,      X_ALLOWANCE_19_NAME
,      X_ALLOWANCE_19_VALUE
,      X_ALLOWANCE_20_NAME
,      X_ALLOWANCE_20_VALUE
,      X_ALLOWANCE_21_NAME
,      X_ALLOWANCE_21_VALUE
,      X_ALLOWANCE_22_NAME
,      X_ALLOWANCE_22_VALUE
,      X_ALLOWANCE_23_NAME
,      X_ALLOWANCE_23_VALUE
,      X_ALLOWANCE_24_NAME
,      X_ALLOWANCE_24_VALUE
,      X_ALLOWANCE_25_NAME
,      X_ALLOWANCE_25_VALUE
,      X_ALLOWANCE_26_NAME
,      X_ALLOWANCE_26_VALUE
,      X_ALLOWANCE_27_NAME
,      X_ALLOWANCE_27_VALUE
,      X_ALLOWANCE_28_NAME
,      X_ALLOWANCE_28_VALUE
,      X_ALLOWANCE_29_NAME
,      X_ALLOWANCE_29_VALUE
,      X_ALLOWANCE_30_NAME
,      X_ALLOWANCE_30_VALUE
,      X_UNION_1_NAME
,      X_UNION_1_VALUE
,      X_UNION_2_NAME
,      X_UNION_2_VALUE
,      X_UNION_3_NAME
,      X_UNION_3_VALUE
,      X_UNION_4_NAME
,      X_UNION_4_VALUE
,      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
,      REPORT_TYPE
,      ASSIGNMENT_NUMBER
FROM APPS.PAY_AU_EOY_VALUES_V;

Dependencies

[top of page]

APPS

PAY_ASSIGNMENT_ACTIONS

PAY_AU_PAYMENT_SUMMARY - show dependent code

PAY_CORE_UTILS - show dependent code

PAY_PAYROLL_ACTIONS

PER_ALL_ASSIGNMENTS_F

APPS

PAY_AU_PAYMENT_SUMMARY_REPORT - show dependent code

PUBLIC

PAY_AU_EOY_VALUES_V