[Home] [Help] [Dependency Information]

VIEW: APPS.HRDPV_CREATE_ELIGIBLE_PERSON

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_ELIG_PER_USER_KEY
,      P_EFFECTIVE_START_DATE
,      P_EFFECTIVE_END_DATE
,      P_PER_IN_LER_ID
,      P_DPNT_OTHR_PL_CVRD_RL_FLAG
,      P_PRTN_OVRIDN_THRU_DT
,      P_PL_KEY_EE_FLAG
,      P_PL_HGHLY_COMPD_FLAG
,      P_ELIG_FLAG
,      P_COMP_REF_AMT
,      P_CMBN_AGE_N_LOS_VAL
,      P_AGE_VAL
,      P_LOS_VAL
,      P_PRTN_END_DT
,      P_PRTN_STRT_DT
,      P_WAIT_PERD_CMPLTN_DT
,      P_WAIT_PERD_STRT_DT
,      P_WV_CTFN_TYP_CD
,      P_HRS_WKD_VAL
,      P_HRS_WKD_BNDRY_PERD_CD
,      P_PRTN_OVRIDN_FLAG
,      P_NO_MX_PRTN_OVRID_THRU_FLAG
,      P_PRTN_OVRIDN_RSN_CD
,      P_AGE_UOM
,      P_LOS_UOM
,      P_OVRID_SVC_DT
,      P_INELG_RSN_CD
,      P_FRZ_LOS_FLAG
,      P_FRZ_AGE_FLAG
,      P_FRZ_CMP_LVL_FLAG
,      P_FRZ_PCT_FL_TM_FLAG
,      P_FRZ_HRS_WKD_FLAG
,      P_FRZ_COMB_AGE_AND_LOS_FLAG
,      P_DSTR_RSTCN_FLAG
,      P_PCT_FL_TM_VAL
,      P_WV_PRTN_RSN_CD
,      P_PL_WVD_FLAG
,      P_RT_COMP_REF_AMT
,      P_RT_CMBN_AGE_N_LOS_VAL
,      P_RT_AGE_VAL
,      P_RT_LOS_VAL
,      P_RT_HRS_WKD_VAL
,      P_RT_HRS_WKD_BNDRY_PERD_CD
,      P_RT_AGE_UOM
,      P_RT_LOS_UOM
,      P_RT_PCT_FL_TM_VAL
,      P_RT_FRZ_LOS_FLAG
,      P_RT_FRZ_AGE_FLAG
,      P_RT_FRZ_CMP_LVL_FLAG
,      P_RT_FRZ_PCT_FL_TM_FLAG
,      P_RT_FRZ_HRS_WKD_FLAG
,      P_RT_FRZ_COMB_AGE_AND_LOS_FLAG
,      P_ONCE_R_CNTUG_CD
,      P_PL_ORDR_NUM
,      P_PLIP_ORDR_NUM
,      P_PTIP_ORDR_NUM
,      P_PEP_ATTRIBUTE_CATEGORY
,      P_PEP_ATTRIBUTE1
,      P_PEP_ATTRIBUTE2
,      P_PEP_ATTRIBUTE3
,      P_PEP_ATTRIBUTE4
,      P_PEP_ATTRIBUTE5
,      P_PEP_ATTRIBUTE6
,      P_PEP_ATTRIBUTE7
,      P_PEP_ATTRIBUTE8
,      P_PEP_ATTRIBUTE9
,      P_PEP_ATTRIBUTE10
,      P_PEP_ATTRIBUTE11
,      P_PEP_ATTRIBUTE12
,      P_PEP_ATTRIBUTE13
,      P_PEP_ATTRIBUTE14
,      P_PEP_ATTRIBUTE15
,      P_PEP_ATTRIBUTE16
,      P_PEP_ATTRIBUTE17
,      P_PEP_ATTRIBUTE18
,      P_PEP_ATTRIBUTE19
,      P_PEP_ATTRIBUTE20
,      P_PEP_ATTRIBUTE21
,      P_PEP_ATTRIBUTE22
,      P_PEP_ATTRIBUTE23
,      P_PEP_ATTRIBUTE24
,      P_PEP_ATTRIBUTE25
,      P_PEP_ATTRIBUTE26
,      P_PEP_ATTRIBUTE27
,      P_PEP_ATTRIBUTE28
,      P_PEP_ATTRIBUTE29
,      P_PEP_ATTRIBUTE30
,      P_PROGRAM_UPDATE_DATE
,      P_OBJECT_VERSION_NUMBER
,      P_EFFECTIVE_DATE
,      P_OVERRIDE_VALIDATION
,      P_PLAN
,      P_PROGRAM
,      P_PLIP_USER_KEY
,      P_PTIP_USER_KEY
,      P_LIFE_EVENT_REASON
,      P_PERSON_USER_KEY
,      P_COMP_REF_UOM
,      P_RT_COMP_REF_UOM
FROM APPS.HRDPV_CREATE_ELIGIBLE_PERSON;

Dependencies

[top of page]

APPS

HR_PUMP_BATCH_LINES

APPS.HRDPV_CREATE_ELIGIBLE_PERSON is not referenced by any database object