[Home] [Help] [Dependency Information]

VIEW: APPS.HRDPV_UPDATE_PLAN_TYPE

Object Details

[View Source]

Columns

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_EFFECTIVE_START_DATE
,      P_EFFECTIVE_END_DATE
,      P_NAME
,      P_MX_ENRL_ALWD_NUM
,      P_MN_ENRL_RQD_NUM
,      P_PL_TYP_STAT_CD
,      P_OPT_TYP_CD
,      P_OPT_DSPLY_FMT_CD
,      P_COMP_TYP_CD
,      P_IVR_IDENT
,      P_NO_MX_ENRL_NUM_DFND_FLAG
,      P_NO_MN_ENRL_NUM_DFND_FLAG
,      P_PTP_ATTRIBUTE_CATEGORY
,      P_PTP_ATTRIBUTE1
,      P_PTP_ATTRIBUTE2
,      P_PTP_ATTRIBUTE3
,      P_PTP_ATTRIBUTE4
,      P_PTP_ATTRIBUTE5
,      P_PTP_ATTRIBUTE6
,      P_PTP_ATTRIBUTE7
,      P_PTP_ATTRIBUTE8
,      P_PTP_ATTRIBUTE9
,      P_PTP_ATTRIBUTE10
,      P_PTP_ATTRIBUTE11
,      P_PTP_ATTRIBUTE12
,      P_PTP_ATTRIBUTE13
,      P_PTP_ATTRIBUTE14
,      P_PTP_ATTRIBUTE15
,      P_PTP_ATTRIBUTE16
,      P_PTP_ATTRIBUTE17
,      P_PTP_ATTRIBUTE18
,      P_PTP_ATTRIBUTE19
,      P_PTP_ATTRIBUTE20
,      P_PTP_ATTRIBUTE21
,      P_PTP_ATTRIBUTE22
,      P_PTP_ATTRIBUTE23
,      P_PTP_ATTRIBUTE24
,      P_PTP_ATTRIBUTE25
,      P_PTP_ATTRIBUTE26
,      P_PTP_ATTRIBUTE27
,      P_PTP_ATTRIBUTE28
,      P_PTP_ATTRIBUTE29
,      P_PTP_ATTRIBUTE30
,      P_EFFECTIVE_DATE
,      P_DATETRACK_MODE
,      P_SHORT_NAME
,      P_SHORT_CODE
,      P_LEGISLATION_CODE
,      P_LEGISLATION_SUBGROUP
,      P_PLAN_TYPE
FROM APPS.HRDPV_UPDATE_PLAN_TYPE;

Dependencies

[top of page]

APPS

HR_PUMP_BATCH_LINES

APPS.HRDPV_UPDATE_PLAN_TYPE is not referenced by any database object