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

VIEW: APPS.HRDPV_UPDATE_ELIG_PERSON_OPTIO

Object Details
Object Name: HRDPV_UPDATE_ELIG_PERSON_OPTIO
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_EFFECTIVE_START_DATE VARCHAR2 (2000)
P_EFFECTIVE_END_DATE VARCHAR2 (2000)
P_PRTN_OVRIDN_FLAG VARCHAR2 (2000)
P_PRTN_OVRIDN_THRU_DT VARCHAR2 (2000)
P_NO_MX_PRTN_OVRID_THRU_FLAG VARCHAR2 (2000)
P_ELIG_FLAG VARCHAR2 (2000)
P_PRTN_STRT_DT VARCHAR2 (2000)
P_PRTN_END_DT VARCHAR2 (2000)
P_WAIT_PERD_CMPLTN_DATE VARCHAR2 (2000)
P_WAIT_PERD_STRT_DT VARCHAR2 (2000)
P_PRTN_OVRIDN_RSN_CD VARCHAR2 (2000)
P_PCT_FL_TM_VAL VARCHAR2 (2000)
P_RT_COMP_REF_AMT VARCHAR2 (2000)
P_RT_CMBN_AGE_N_LOS_VAL VARCHAR2 (2000)
P_RT_AGE_VAL VARCHAR2 (2000)
P_RT_LOS_VAL VARCHAR2 (2000)
P_RT_HRS_WKD_VAL VARCHAR2 (2000)
P_RT_HRS_WKD_BNDRY_PERD_CD VARCHAR2 (2000)
P_RT_AGE_UOM VARCHAR2 (2000)
P_RT_LOS_UOM VARCHAR2 (2000)
P_RT_PCT_FL_TM_VAL VARCHAR2 (2000)
P_RT_FRZ_LOS_FLAG VARCHAR2 (2000)
P_RT_FRZ_AGE_FLAG VARCHAR2 (2000)
P_RT_FRZ_CMP_LVL_FLAG VARCHAR2 (2000)
P_RT_FRZ_PCT_FL_TM_FLAG VARCHAR2 (2000)
P_RT_FRZ_HRS_WKD_FLAG VARCHAR2 (2000)
P_RT_FRZ_COMB_AGE_AND_LOS_FLAG VARCHAR2 (2000)
P_COMP_REF_AMT VARCHAR2 (2000)
P_CMBN_AGE_N_LOS_VAL VARCHAR2 (2000)
P_AGE_VAL VARCHAR2 (2000)
P_LOS_VAL VARCHAR2 (2000)
P_HRS_WKD_VAL VARCHAR2 (2000)
P_HRS_WKD_BNDRY_PERD_CD VARCHAR2 (2000)
P_AGE_UOM VARCHAR2 (2000)
P_LOS_UOM VARCHAR2 (2000)
P_FRZ_LOS_FLAG VARCHAR2 (2000)
P_FRZ_AGE_FLAG VARCHAR2 (2000)
P_FRZ_CMP_LVL_FLAG VARCHAR2 (2000)
P_FRZ_PCT_FL_TM_FLAG VARCHAR2 (2000)
P_FRZ_HRS_WKD_FLAG VARCHAR2 (2000)
P_FRZ_COMB_AGE_AND_LOS_FLAG VARCHAR2 (2000)
P_OVRID_SVC_DT VARCHAR2 (2000)
P_INELG_RSN_CD VARCHAR2 (2000)
P_ONCE_R_CNTUG_CD VARCHAR2 (2000)
P_OIPL_ORDR_NUM VARCHAR2 (2000)
P_EPO_ATTRIBUTE_CATEGORY VARCHAR2 (2000)
P_EPO_ATTRIBUTE1 VARCHAR2 (2000)
P_EPO_ATTRIBUTE2 VARCHAR2 (2000)
P_EPO_ATTRIBUTE3 VARCHAR2 (2000)
P_EPO_ATTRIBUTE4 VARCHAR2 (2000)
P_EPO_ATTRIBUTE5 VARCHAR2 (2000)
P_EPO_ATTRIBUTE6 VARCHAR2 (2000)
P_EPO_ATTRIBUTE7 VARCHAR2 (2000)
P_EPO_ATTRIBUTE8 VARCHAR2 (2000)
P_EPO_ATTRIBUTE9 VARCHAR2 (2000)
P_EPO_ATTRIBUTE10 VARCHAR2 (2000)
P_EPO_ATTRIBUTE11 VARCHAR2 (2000)
P_EPO_ATTRIBUTE12 VARCHAR2 (2000)
P_EPO_ATTRIBUTE13 VARCHAR2 (2000)
P_EPO_ATTRIBUTE14 VARCHAR2 (2000)
P_EPO_ATTRIBUTE15 VARCHAR2 (2000)
P_EPO_ATTRIBUTE16 VARCHAR2 (2000)
P_EPO_ATTRIBUTE17 VARCHAR2 (2000)
P_EPO_ATTRIBUTE18 VARCHAR2 (2000)
P_EPO_ATTRIBUTE19 VARCHAR2 (2000)
P_EPO_ATTRIBUTE20 VARCHAR2 (2000)
P_EPO_ATTRIBUTE21 VARCHAR2 (2000)
P_EPO_ATTRIBUTE22 VARCHAR2 (2000)
P_EPO_ATTRIBUTE23 VARCHAR2 (2000)
P_EPO_ATTRIBUTE24 VARCHAR2 (2000)
P_EPO_ATTRIBUTE25 VARCHAR2 (2000)
P_EPO_ATTRIBUTE26 VARCHAR2 (2000)
P_EPO_ATTRIBUTE27 VARCHAR2 (2000)
P_EPO_ATTRIBUTE28 VARCHAR2 (2000)
P_EPO_ATTRIBUTE29 VARCHAR2 (2000)
P_EPO_ATTRIBUTE30 VARCHAR2 (2000)
P_PROGRAM_UPDATE_DATE VARCHAR2 (2000)
P_EFFECTIVE_DATE VARCHAR2 (2000)
P_DATETRACK_MODE VARCHAR2 (2000)
P_ELIG_PER_OPT_USER_KEY VARCHAR2 (2000)
P_ELIG_PER_USER_KEY VARCHAR2 (2000)
P_OPTION_DEFINITION VARCHAR2 (2000)
P_PER_IN_LER_USER_KEY VARCHAR2 (2000)
P_RT_COMP_REF_UOM VARCHAR2 (2000)
P_COMP_REF_UOM 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_EFFECTIVE_START_DATE
,      P_EFFECTIVE_END_DATE
,      P_PRTN_OVRIDN_FLAG
,      P_PRTN_OVRIDN_THRU_DT
,      P_NO_MX_PRTN_OVRID_THRU_FLAG
,      P_ELIG_FLAG
,      P_PRTN_STRT_DT
,      P_PRTN_END_DT
,      P_WAIT_PERD_CMPLTN_DATE
,      P_WAIT_PERD_STRT_DT
,      P_PRTN_OVRIDN_RSN_CD
,      P_PCT_FL_TM_VAL
,      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_COMP_REF_AMT
,      P_CMBN_AGE_N_LOS_VAL
,      P_AGE_VAL
,      P_LOS_VAL
,      P_HRS_WKD_VAL
,      P_HRS_WKD_BNDRY_PERD_CD
,      P_AGE_UOM
,      P_LOS_UOM
,      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_OVRID_SVC_DT
,      P_INELG_RSN_CD
,      P_ONCE_R_CNTUG_CD
,      P_OIPL_ORDR_NUM
,      P_EPO_ATTRIBUTE_CATEGORY
,      P_EPO_ATTRIBUTE1
,      P_EPO_ATTRIBUTE2
,      P_EPO_ATTRIBUTE3
,      P_EPO_ATTRIBUTE4
,      P_EPO_ATTRIBUTE5
,      P_EPO_ATTRIBUTE6
,      P_EPO_ATTRIBUTE7
,      P_EPO_ATTRIBUTE8
,      P_EPO_ATTRIBUTE9
,      P_EPO_ATTRIBUTE10
,      P_EPO_ATTRIBUTE11
,      P_EPO_ATTRIBUTE12
,      P_EPO_ATTRIBUTE13
,      P_EPO_ATTRIBUTE14
,      P_EPO_ATTRIBUTE15
,      P_EPO_ATTRIBUTE16
,      P_EPO_ATTRIBUTE17
,      P_EPO_ATTRIBUTE18
,      P_EPO_ATTRIBUTE19
,      P_EPO_ATTRIBUTE20
,      P_EPO_ATTRIBUTE21
,      P_EPO_ATTRIBUTE22
,      P_EPO_ATTRIBUTE23
,      P_EPO_ATTRIBUTE24
,      P_EPO_ATTRIBUTE25
,      P_EPO_ATTRIBUTE26
,      P_EPO_ATTRIBUTE27
,      P_EPO_ATTRIBUTE28
,      P_EPO_ATTRIBUTE29
,      P_EPO_ATTRIBUTE30
,      P_PROGRAM_UPDATE_DATE
,      P_EFFECTIVE_DATE
,      P_DATETRACK_MODE
,      P_ELIG_PER_OPT_USER_KEY
,      P_ELIG_PER_USER_KEY
,      P_OPTION_DEFINITION
,      P_PER_IN_LER_USER_KEY
,      P_RT_COMP_REF_UOM
,      P_COMP_REF_UOM
FROM APPS.HRDPV_UPDATE_ELIG_PERSON_OPTIO;

Dependencies

[top of page]

APPS.HRDPV_UPDATE_ELIG_PERSON_OPTIO references the following:

SchemaAPPS
SynonymHR_PUMP_BATCH_LINES

APPS.HRDPV_UPDATE_ELIG_PERSON_OPTIO is not referenced by any database object