[Home] [Help] [Dependency Information]
Object Name: | HRDPV_PROCESS_BENEFICIARY |
---|---|
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_BNFT_VAL | VARCHAR2 | (2000) | ||
P_LIFE_EVENT_DATE | VARCHAR2 | (2000) | ||
P_EFFECTIVE_DATE | VARCHAR2 | (2000) | ||
P_DSGN_STRT_DT | VARCHAR2 | (2000) | ||
P_DSGN_THRU_DT | VARCHAR2 | (2000) | ||
P_PRMRY_CNTNGNT_CD | VARCHAR2 | (2000) | ||
P_PCT_DSGD_NUM | VARCHAR2 | (2000) | ||
P_AMT_DSGD_VAL | VARCHAR2 | (2000) | ||
P_AMT_DSGD_UOM | VARCHAR2 | (2000) | ||
P_ADDL_INSTRN_TXT | VARCHAR2 | (2000) | ||
P_MULTI_ROW_ACTN | VARCHAR2 | (2000) | ||
P_RECORD_TYP_CD | 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_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_CON_EMPLOYEE_NUMBER | VARCHAR2 | (2000) | ||
P_CON_NATIONAL_IDENTIFIER | VARCHAR2 | (2000) | ||
P_CON_FULL_NAME | VARCHAR2 | (2000) | ||
P_CON_DATE_OF_BIRTH | VARCHAR2 | (2000) | ||
P_CON_PERSON_NUM | VARCHAR2 | (2000) | ||
P_ORGANIZATION_NAME | VARCHAR2 | (2000) | ||
P_LANGUAGE_CODE | VARCHAR2 | (2000) | ||
P_TTEE_PERSON_USER_KEY | 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_BNFT_VAL
, P_LIFE_EVENT_DATE
, P_EFFECTIVE_DATE
, P_DSGN_STRT_DT
, P_DSGN_THRU_DT
, P_PRMRY_CNTNGNT_CD
, P_PCT_DSGD_NUM
, P_AMT_DSGD_VAL
, P_AMT_DSGD_UOM
, P_ADDL_INSTRN_TXT
, P_MULTI_ROW_ACTN
, P_RECORD_TYP_CD
, P_EMPLOYEE_NUMBER
, P_NATIONAL_IDENTIFIER
, P_FULL_NAME
, P_DATE_OF_BIRTH
, P_PERSON_NUM
, P_PROGRAM
, P_PROGRAM_NUM
, P_PLAN
, P_PLAN_NUM
, P_OPTION
, P_OPTION_NUM
, P_LIFE_EVENT_REASON
, P_CON_EMPLOYEE_NUMBER
, P_CON_NATIONAL_IDENTIFIER
, P_CON_FULL_NAME
, P_CON_DATE_OF_BIRTH
, P_CON_PERSON_NUM
, P_ORGANIZATION_NAME
, P_LANGUAGE_CODE
, P_TTEE_PERSON_USER_KEY
FROM APPS.HRDPV_PROCESS_BENEFICIARY;
|
|
|