[Home] [Help]
[Dependency Information]
| Object Name: | PAY_CA_ROE_VALUES_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | PAY.PAY_CA_ROE_VALUES_V
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Cut, paste (and edit) the following text to query this object:
SELECT PAYROLL_ACTION_ID
, ASSIGNMENT_ACTION_ID
, EFFECTIVE_DATE
, ASSIGNMENT_ID
, BUSINESS_GROUP_ID
, ROE_SERIAL_NUMBER
, ROE_PREVIOUS_SERIAL_NUMBER
, ROE_PAYROLL_REFERENCE_NUMBER
, ROE_TAX_UNIT_NAME
, ROE_TAX_UNIT_ADDRESS_LINE_1
, ROE_TAX_UNIT_ADDRESS_LINE_2
, ROE_TAX_UNIT_ADDRESS_LINE_3
, ROE_TAX_UNIT_PROVINCE
, ROE_TAX_UNIT_CITY
, ROE_TAX_UNIT_COUNTRY
, ROE_CA_EMPLR_IDENT_ORG_BUS_NO
, ROE_PAY_PERIOD_TYPE
, ROE_TAX_UNIT_POSTAL_CODE
, ROE_PER_SOCIAL_INSURANCE_NUMBR
, ROE_PER_FIRST_NAME
, ROE_PER_LAST_NAME
, ROE_PER_ADDRESS_LINE_1
, ROE_PER_ADDRESS_LINE_2
, ROE_PER_ADDRESS_LINE_3
, ROE_PER_PROVINCE
, ROE_PER_CITY
, ROE_PER_COUNTRY
, ROE_PER_POSTAL_CODE
, ROE_EMP_PER_HIRE_DATE
, ROE_PAY_EARNED_END_DATE
, ROE_FINAL_PAY_PERIOD_END_DATE
, ROE_ASG_JOB
, ROE_UNKNOWN_NOT_RETURNING
, ROE_EXPECTED_DATE_OF_RECALL
, ROE_TOTAL_INSURABLE_HOURS
, ROE_TOTAL_INSURABLE_EARNINGS
, ROE_INSURABLE_EARNING_1
, ROE_INSURABLE_EARNING_2
, ROE_INSURABLE_EARNING_3
, ROE_INSURABLE_EARNING_4
, ROE_INSURABLE_EARNING_5
, ROE_INSURABLE_EARNING_6
, ROE_INSURABLE_EARNING_7
, ROE_INSURABLE_EARNING_8
, ROE_INSURABLE_EARNING_9
, ROE_INSURABLE_EARNING_10
, ROE_INSURABLE_EARNING_11
, ROE_INSURABLE_EARNING_12
, ROE_INSURABLE_EARNING_13
, ROE_INSURABLE_EARNING_14
, ROE_INSURABLE_EARNING_15
, ROE_INSURABLE_EARNING_16
, ROE_INSURABLE_EARNING_17
, ROE_INSURABLE_EARNING_18
, ROE_INSURABLE_EARNING_19
, ROE_INSURABLE_EARNING_20
, ROE_INSURABLE_EARNING_21
, ROE_INSURABLE_EARNING_22
, ROE_INSURABLE_EARNING_23
, ROE_INSURABLE_EARNING_24
, ROE_INSURABLE_EARNING_25
, ROE_INSURABLE_EARNING_26
, ROE_INSURABLE_EARNING_27
, ROE_INSURABLE_EARNING_28
, ROE_INSURABLE_EARNING_29
, ROE_INSURABLE_EARNING_30
, ROE_INSURABLE_EARNING_31
, ROE_INSURABLE_EARNING_32
, ROE_INSURABLE_EARNING_33
, ROE_INSURABLE_EARNING_34
, ROE_INSURABLE_EARNING_35
, ROE_INSURABLE_EARNING_36
, ROE_INSURABLE_EARNING_37
, ROE_INSURABLE_EARNING_38
, ROE_INSURABLE_EARNING_39
, ROE_INSURABLE_EARNING_40
, ROE_INSURABLE_EARNING_41
, ROE_INSURABLE_EARNING_42
, ROE_INSURABLE_EARNING_43
, ROE_INSURABLE_EARNING_44
, ROE_INSURABLE_EARNING_45
, ROE_INSURABLE_EARNING_46
, ROE_INSURABLE_EARNING_47
, ROE_INSURABLE_EARNING_48
, ROE_INSURABLE_EARNING_49
, ROE_INSURABLE_EARNING_50
, ROE_INSURABLE_EARNING_51
, ROE_INSURABLE_EARNING_52
, ROE_INSURABLE_EARNING_53
, ROE_REASON
, ROE_CONTACT_PERSON
, ROE_CONTACT_PHONE_NUMBER
, ROE_BOX_17A
, ROE_BOX_17B_DATE1
, ROE_BOX_17B_AMOUNT1
, ROE_BOX_17B_DATE2
, ROE_BOX_17B_AMOUNT2
, ROE_BOX_17B_DATE3
, ROE_BOX_17B_AMOUNT3
, ROE_BOX_17C_DESC1
, ROE_BOX_17C_AMOUNT1
, ROE_BOX_17C_DESC2
, ROE_BOX_17C_AMOUNT2
, ROE_BOX_17C_DESC3
, ROE_BOX_17C_AMOUNT3
, ROE_COMMENTS
, ROE_BOX_19_PAYMENT_START_DATE
, ROE_BOX_19_PAYMENT_AMOUNT
, ROE_BOX_19_DAY_WEEK
, ROE_PER_CORRESPONDENCE_LANG
, ROE_PER_TELEPHONE_NUMBER
, ROE_ISSUER
, ROE_INCLUDE_EXCLUDE
, ROE_MANUAL
, ROE_DATE
FROM APPS.PAY_CA_ROE_VALUES_V;
APPS
PAY_ASSIGNMENT_ACTIONS
PAY_CA_ARCHIVE_UTILS
- show dependent code
PAY_PAYROLL_ACTIONS
APPS.PAY_CA_ROE_VALUES_V is not referenced by any database object
|
|
|
|