DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.HRDPV_CREATE_PLAN_BENEFICIARY

Object Details
Object Name: HRDPV_CREATE_PLAN_BENEFICIARY
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
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_PL_BNF_USER_KEY VARCHAR2 (2000)
P_EFFECTIVE_START_DATE VARCHAR2 (2000)
P_EFFECTIVE_END_DATE VARCHAR2 (2000)
P_PRMRY_CNTNGNT_CD VARCHAR2 (2000)
P_PCT_DSGD_NUM VARCHAR2 (2000)
P_AMT_DSGD_VAL VARCHAR2 (2000)
P_DSGN_STRT_DT VARCHAR2 (2000)
P_DSGN_THRU_DT VARCHAR2 (2000)
P_ADDL_INSTRN_TXT VARCHAR2 (2000)
P_PBN_ATTRIBUTE_CATEGORY VARCHAR2 (2000)
P_PBN_ATTRIBUTE1 VARCHAR2 (2000)
P_PBN_ATTRIBUTE2 VARCHAR2 (2000)
P_PBN_ATTRIBUTE3 VARCHAR2 (2000)
P_PBN_ATTRIBUTE4 VARCHAR2 (2000)
P_PBN_ATTRIBUTE5 VARCHAR2 (2000)
P_PBN_ATTRIBUTE6 VARCHAR2 (2000)
P_PBN_ATTRIBUTE7 VARCHAR2 (2000)
P_PBN_ATTRIBUTE8 VARCHAR2 (2000)
P_PBN_ATTRIBUTE9 VARCHAR2 (2000)
P_PBN_ATTRIBUTE10 VARCHAR2 (2000)
P_PBN_ATTRIBUTE11 VARCHAR2 (2000)
P_PBN_ATTRIBUTE12 VARCHAR2 (2000)
P_PBN_ATTRIBUTE13 VARCHAR2 (2000)
P_PBN_ATTRIBUTE14 VARCHAR2 (2000)
P_PBN_ATTRIBUTE15 VARCHAR2 (2000)
P_PBN_ATTRIBUTE16 VARCHAR2 (2000)
P_PBN_ATTRIBUTE17 VARCHAR2 (2000)
P_PBN_ATTRIBUTE18 VARCHAR2 (2000)
P_PBN_ATTRIBUTE19 VARCHAR2 (2000)
P_PBN_ATTRIBUTE20 VARCHAR2 (2000)
P_PBN_ATTRIBUTE21 VARCHAR2 (2000)
P_PBN_ATTRIBUTE22 VARCHAR2 (2000)
P_PBN_ATTRIBUTE23 VARCHAR2 (2000)
P_PBN_ATTRIBUTE24 VARCHAR2 (2000)
P_PBN_ATTRIBUTE25 VARCHAR2 (2000)
P_PBN_ATTRIBUTE26 VARCHAR2 (2000)
P_PBN_ATTRIBUTE27 VARCHAR2 (2000)
P_PBN_ATTRIBUTE28 VARCHAR2 (2000)
P_PBN_ATTRIBUTE29 VARCHAR2 (2000)
P_PBN_ATTRIBUTE30 VARCHAR2 (2000)
P_PROGRAM_UPDATE_DATE VARCHAR2 (2000)
P_OBJECT_VERSION_NUMBER VARCHAR2 (2000)
P_EFFECTIVE_DATE VARCHAR2 (2000)
P_MULTI_ROW_ACTN VARCHAR2 (2000)
P_PRTT_ENRT_RSLT_USER_KEY VARCHAR2 (2000)
P_BNF_PERSON_USER_KEY VARCHAR2 (2000)
P_ORGANIZATION_NAME VARCHAR2 (2000)
P_LANGUAGE_CODE VARCHAR2 (2000)
P_TTEE_PERSON_USER_KEY VARCHAR2 (2000)
P_AMT_DSGD_UOM VARCHAR2 (2000)
P_PER_IN_LER_USER_KEY VARCHAR2 (2000)
Query Text

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_PL_BNF_USER_KEY
,      P_EFFECTIVE_START_DATE
,      P_EFFECTIVE_END_DATE
,      P_PRMRY_CNTNGNT_CD
,      P_PCT_DSGD_NUM
,      P_AMT_DSGD_VAL
,      P_DSGN_STRT_DT
,      P_DSGN_THRU_DT
,      P_ADDL_INSTRN_TXT
,      P_PBN_ATTRIBUTE_CATEGORY
,      P_PBN_ATTRIBUTE1
,      P_PBN_ATTRIBUTE2
,      P_PBN_ATTRIBUTE3
,      P_PBN_ATTRIBUTE4
,      P_PBN_ATTRIBUTE5
,      P_PBN_ATTRIBUTE6
,      P_PBN_ATTRIBUTE7
,      P_PBN_ATTRIBUTE8
,      P_PBN_ATTRIBUTE9
,      P_PBN_ATTRIBUTE10
,      P_PBN_ATTRIBUTE11
,      P_PBN_ATTRIBUTE12
,      P_PBN_ATTRIBUTE13
,      P_PBN_ATTRIBUTE14
,      P_PBN_ATTRIBUTE15
,      P_PBN_ATTRIBUTE16
,      P_PBN_ATTRIBUTE17
,      P_PBN_ATTRIBUTE18
,      P_PBN_ATTRIBUTE19
,      P_PBN_ATTRIBUTE20
,      P_PBN_ATTRIBUTE21
,      P_PBN_ATTRIBUTE22
,      P_PBN_ATTRIBUTE23
,      P_PBN_ATTRIBUTE24
,      P_PBN_ATTRIBUTE25
,      P_PBN_ATTRIBUTE26
,      P_PBN_ATTRIBUTE27
,      P_PBN_ATTRIBUTE28
,      P_PBN_ATTRIBUTE29
,      P_PBN_ATTRIBUTE30
,      P_PROGRAM_UPDATE_DATE
,      P_OBJECT_VERSION_NUMBER
,      P_EFFECTIVE_DATE
,      P_MULTI_ROW_ACTN
,      P_PRTT_ENRT_RSLT_USER_KEY
,      P_BNF_PERSON_USER_KEY
,      P_ORGANIZATION_NAME
,      P_LANGUAGE_CODE
,      P_TTEE_PERSON_USER_KEY
,      P_AMT_DSGD_UOM
,      P_PER_IN_LER_USER_KEY
FROM APPS.HRDPV_CREATE_PLAN_BENEFICIARY;

Dependencies

[top of page]

APPS.HRDPV_CREATE_PLAN_BENEFICIARY references the following:

SchemaAPPS
SynonymHR_PUMP_BATCH_LINES

APPS.HRDPV_CREATE_PLAN_BENEFICIARY is not referenced by any database object