[Home] [Help] [Dependency Information]
Object Name: | HRDPV_CREATE_ENROLLMENT |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | (15) | Yes | |
BATCH_LINE_ID | NUMBER | (15) | Yes | |
API_MODULE_ID | NUMBER | (15) | Yes | |
LINE_STATUS | VARCHAR2 | (1) | Yes | |
USER_SEQUENCE | NUMBER | (15) | ||
LINK_VALUE | NUMBER | (15) | ||
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | ||
P_LIFE_EVENT_DATE | VARCHAR2 | (2000) | ||
P_ENDED_BNFT_VAL | VARCHAR2 | (2000) | ||
P_EFFECTIVE_DATE | VARCHAR2 | (2000) | ||
P_BNFT_VAL | VARCHAR2 | (2000) | ||
P_RT_VAL1 | VARCHAR2 | (2000) | ||
P_ANN_RT_VAL1 | VARCHAR2 | (2000) | ||
P_RT_STRT_DT1 | VARCHAR2 | (2000) | ||
P_RT_END_DT1 | VARCHAR2 | (2000) | ||
P_RT_VAL2 | VARCHAR2 | (2000) | ||
P_ANN_RT_VAL2 | VARCHAR2 | (2000) | ||
P_RT_STRT_DT2 | VARCHAR2 | (2000) | ||
P_RT_END_DT2 | VARCHAR2 | (2000) | ||
P_RT_VAL3 | VARCHAR2 | (2000) | ||
P_ANN_RT_VAL3 | VARCHAR2 | (2000) | ||
P_RT_STRT_DT3 | VARCHAR2 | (2000) | ||
P_RT_END_DT3 | VARCHAR2 | (2000) | ||
P_RT_VAL4 | VARCHAR2 | (2000) | ||
P_ANN_RT_VAL4 | VARCHAR2 | (2000) | ||
P_RT_STRT_DT4 | VARCHAR2 | (2000) | ||
P_RT_END_DT4 | VARCHAR2 | (2000) | ||
P_ENRT_CVG_STRT_DT | VARCHAR2 | (2000) | ||
P_ENRT_CVG_THRU_DT | VARCHAR2 | (2000) | ||
P_ORGNL_ENRT_DT | VARCHAR2 | (2000) | ||
P_PROC_CD | VARCHAR2 | (2000) | ||
P_RECORD_TYP_CD | VARCHAR2 | (2000) | ||
P_PROGRAM | VARCHAR2 | (2000) | ||
P_PROGRAM_NUM | VARCHAR2 | (2000) | ||
P_PLAN | VARCHAR2 | (2000) | ||
P_PLAN_NUM | VARCHAR2 | (2000) | ||
P_OPTION | VARCHAR2 | (2000) | ||
P_OPTION_NUM | VARCHAR2 | (2000) | ||
P_LIFE_EVENT_REASON | VARCHAR2 | (2000) | ||
P_ENDED_PLAN | VARCHAR2 | (2000) | ||
P_ENDED_PLAN_NUM | VARCHAR2 | (2000) | ||
P_ENDED_OPTION | VARCHAR2 | (2000) | ||
P_ENDED_OPTION_NUM | VARCHAR2 | (2000) | ||
P_EMPLOYEE_NUMBER | VARCHAR2 | (2000) | ||
P_NATIONAL_IDENTIFIER | VARCHAR2 | (2000) | ||
P_FULL_NAME | VARCHAR2 | (2000) | ||
P_DATE_OF_BIRTH | VARCHAR2 | (2000) | ||
P_PERSON_NUM | VARCHAR2 | (2000) | ||
P_ACTY_BASE_RATE_NAME1 | VARCHAR2 | (2000) | ||
P_ACTY_BASE_RATE_NUM1 | VARCHAR2 | (2000) | ||
P_ACTY_BASE_RATE_NAME2 | VARCHAR2 | (2000) | ||
P_ACTY_BASE_RATE_NUM2 | VARCHAR2 | (2000) | ||
P_ACTY_BASE_RATE_NAME3 | VARCHAR2 | (2000) | ||
P_ACTY_BASE_RATE_NUM3 | VARCHAR2 | (2000) | ||
P_ACTY_BASE_RATE_NAME4 | VARCHAR2 | (2000) | ||
P_ACTY_BASE_RATE_NUM4 | VARCHAR2 | (2000) |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, BATCH_LINE_ID
, API_MODULE_ID
, LINE_STATUS
, USER_SEQUENCE
, LINK_VALUE
, BUSINESS_GROUP_NAME
, P_LIFE_EVENT_DATE
, P_ENDED_BNFT_VAL
, P_EFFECTIVE_DATE
, P_BNFT_VAL
, P_RT_VAL1
, P_ANN_RT_VAL1
, P_RT_STRT_DT1
, P_RT_END_DT1
, P_RT_VAL2
, P_ANN_RT_VAL2
, P_RT_STRT_DT2
, P_RT_END_DT2
, P_RT_VAL3
, P_ANN_RT_VAL3
, P_RT_STRT_DT3
, P_RT_END_DT3
, P_RT_VAL4
, P_ANN_RT_VAL4
, P_RT_STRT_DT4
, P_RT_END_DT4
, P_ENRT_CVG_STRT_DT
, P_ENRT_CVG_THRU_DT
, P_ORGNL_ENRT_DT
, P_PROC_CD
, P_RECORD_TYP_CD
, P_PROGRAM
, P_PROGRAM_NUM
, P_PLAN
, P_PLAN_NUM
, P_OPTION
, P_OPTION_NUM
, P_LIFE_EVENT_REASON
, P_ENDED_PLAN
, P_ENDED_PLAN_NUM
, P_ENDED_OPTION
, P_ENDED_OPTION_NUM
, P_EMPLOYEE_NUMBER
, P_NATIONAL_IDENTIFIER
, P_FULL_NAME
, P_DATE_OF_BIRTH
, P_PERSON_NUM
, P_ACTY_BASE_RATE_NAME1
, P_ACTY_BASE_RATE_NUM1
, P_ACTY_BASE_RATE_NAME2
, P_ACTY_BASE_RATE_NUM2
, P_ACTY_BASE_RATE_NAME3
, P_ACTY_BASE_RATE_NUM3
, P_ACTY_BASE_RATE_NAME4
, P_ACTY_BASE_RATE_NUM4
FROM APPS.HRDPV_CREATE_ENROLLMENT;
|
|
|