[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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PAYROLL_ACTION_ID | NUMBER | (9) | Yes | |
ASSIGNMENT_ACTION_ID | NUMBER | (15) | Yes | |
EFFECTIVE_DATE | DATE | Yes | ||
ASSIGNMENT_ID | NUMBER | (10) | ||
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
ROE_SERIAL_NUMBER | VARCHAR2 | (4000) | ||
ROE_PREVIOUS_SERIAL_NUMBER | VARCHAR2 | (4000) | ||
ROE_PAYROLL_REFERENCE_NUMBER | VARCHAR2 | (4000) | ||
ROE_TAX_UNIT_NAME | VARCHAR2 | (4000) | ||
ROE_TAX_UNIT_ADDRESS_LINE_1 | VARCHAR2 | (4000) | ||
ROE_TAX_UNIT_ADDRESS_LINE_2 | VARCHAR2 | (4000) | ||
ROE_TAX_UNIT_ADDRESS_LINE_3 | VARCHAR2 | (4000) | ||
ROE_TAX_UNIT_PROVINCE | VARCHAR2 | (4000) | ||
ROE_TAX_UNIT_CITY | VARCHAR2 | (4000) | ||
ROE_TAX_UNIT_COUNTRY | VARCHAR2 | (4000) | ||
ROE_CA_EMPLR_IDENT_ORG_BUS_NO | VARCHAR2 | (4000) | ||
ROE_PAY_PERIOD_TYPE | VARCHAR2 | (4000) | ||
ROE_TAX_UNIT_POSTAL_CODE | VARCHAR2 | (4000) | ||
ROE_PER_SOCIAL_INSURANCE_NUMBR | VARCHAR2 | (4000) | ||
ROE_PER_FIRST_NAME | VARCHAR2 | (4000) | ||
ROE_PER_LAST_NAME | VARCHAR2 | (4000) | ||
ROE_PER_ADDRESS_LINE_1 | VARCHAR2 | (4000) | ||
ROE_PER_ADDRESS_LINE_2 | VARCHAR2 | (4000) | ||
ROE_PER_ADDRESS_LINE_3 | VARCHAR2 | (4000) | ||
ROE_PER_PROVINCE | VARCHAR2 | (4000) | ||
ROE_PER_CITY | VARCHAR2 | (4000) | ||
ROE_PER_COUNTRY | VARCHAR2 | (4000) | ||
ROE_PER_POSTAL_CODE | VARCHAR2 | (4000) | ||
ROE_EMP_PER_HIRE_DATE | VARCHAR2 | (4000) | ||
ROE_PAY_EARNED_END_DATE | VARCHAR2 | (4000) | ||
ROE_FINAL_PAY_PERIOD_END_DATE | VARCHAR2 | (4000) | ||
ROE_ASG_JOB | VARCHAR2 | (4000) | ||
ROE_UNKNOWN_NOT_RETURNING | VARCHAR2 | (4000) | ||
ROE_EXPECTED_DATE_OF_RECALL | VARCHAR2 | (4000) | ||
ROE_TOTAL_INSURABLE_HOURS | VARCHAR2 | (4000) | ||
ROE_TOTAL_INSURABLE_EARNINGS | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_1 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_2 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_3 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_4 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_5 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_6 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_7 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_8 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_9 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_10 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_11 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_12 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_13 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_14 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_15 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_16 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_17 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_18 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_19 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_20 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_21 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_22 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_23 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_24 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_25 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_26 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_27 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_28 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_29 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_30 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_31 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_32 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_33 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_34 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_35 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_36 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_37 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_38 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_39 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_40 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_41 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_42 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_43 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_44 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_45 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_46 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_47 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_48 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_49 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_50 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_51 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_52 | VARCHAR2 | (4000) | ||
ROE_INSURABLE_EARNING_53 | VARCHAR2 | (4000) | ||
ROE_REASON | VARCHAR2 | (4000) | ||
ROE_CONTACT_PERSON | VARCHAR2 | (4000) | ||
ROE_CONTACT_PHONE_NUMBER | VARCHAR2 | (4000) | ||
ROE_BOX_17A | VARCHAR2 | (4000) | ||
ROE_BOX_17B_DATE1 | VARCHAR2 | (4000) | ||
ROE_BOX_17B_AMOUNT1 | VARCHAR2 | (4000) | ||
ROE_BOX_17B_DATE2 | VARCHAR2 | (4000) | ||
ROE_BOX_17B_AMOUNT2 | VARCHAR2 | (4000) | ||
ROE_BOX_17B_DATE3 | VARCHAR2 | (4000) | ||
ROE_BOX_17B_AMOUNT3 | VARCHAR2 | (4000) | ||
ROE_BOX_17C_DESC1 | VARCHAR2 | (4000) | ||
ROE_BOX_17C_AMOUNT1 | VARCHAR2 | (4000) | ||
ROE_BOX_17C_DESC2 | VARCHAR2 | (4000) | ||
ROE_BOX_17C_AMOUNT2 | VARCHAR2 | (4000) | ||
ROE_BOX_17C_DESC3 | VARCHAR2 | (4000) | ||
ROE_BOX_17C_AMOUNT3 | VARCHAR2 | (4000) | ||
ROE_COMMENTS | VARCHAR2 | (4000) | ||
ROE_BOX_19_PAYMENT_START_DATE | VARCHAR2 | (4000) | ||
ROE_BOX_19_PAYMENT_AMOUNT | VARCHAR2 | (4000) | ||
ROE_BOX_19_DAY_WEEK | VARCHAR2 | (4000) | ||
ROE_PER_CORRESPONDENCE_LANG | VARCHAR2 | (4000) | ||
ROE_PER_TELEPHONE_NUMBER | VARCHAR2 | (4000) | ||
ROE_ISSUER | VARCHAR2 | (4000) | ||
ROE_INCLUDE_EXCLUDE | VARCHAR2 | (4000) | ||
ROE_MANUAL | VARCHAR2 | (4000) | ||
ROE_DATE | VARCHAR2 | (4000) |
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;
|
|
|