VIEW: APPS.HRDPV_UPDATE_ELIG_PERSON_OPTIO

Source

View Text - Preformatted

select batch_id            batch_id
,      batch_line_id       batch_line_id
,      api_module_id       api_module_id
,      line_status         line_status
,      user_sequence       user_sequence
,      link_value          link_value
,      business_group_name business_group_name,
       pval001 P_EFFECTIVE_START_DATE,
       pval002 P_EFFECTIVE_END_DATE,
       pval003 P_PRTN_OVRIDN_FLAG,
       pval004 P_PRTN_OVRIDN_THRU_DT,
       pval005 P_NO_MX_PRTN_OVRID_THRU_FLAG,
       pval006 P_ELIG_FLAG,
       pval007 P_PRTN_STRT_DT,
       pval008 P_PRTN_END_DT,
       pval009 P_WAIT_PERD_CMPLTN_DATE,
       pval010 P_WAIT_PERD_STRT_DT,
       pval011 P_PRTN_OVRIDN_RSN_CD,
       pval012 P_PCT_FL_TM_VAL,
       pval013 P_RT_COMP_REF_AMT,
       pval014 P_RT_CMBN_AGE_N_LOS_VAL,
       pval015 P_RT_AGE_VAL,
       pval016 P_RT_LOS_VAL,
       pval017 P_RT_HRS_WKD_VAL,
       pval018 P_RT_HRS_WKD_BNDRY_PERD_CD,
       pval019 P_RT_AGE_UOM,
       pval020 P_RT_LOS_UOM,
       pval021 P_RT_PCT_FL_TM_VAL,
       pval022 P_RT_FRZ_LOS_FLAG,
       pval023 P_RT_FRZ_AGE_FLAG,
       pval024 P_RT_FRZ_CMP_LVL_FLAG,
       pval025 P_RT_FRZ_PCT_FL_TM_FLAG,
       pval026 P_RT_FRZ_HRS_WKD_FLAG,
       pval027 P_RT_FRZ_COMB_AGE_AND_LOS_FLAG,
       pval028 P_COMP_REF_AMT,
       pval029 P_CMBN_AGE_N_LOS_VAL,
       pval030 P_AGE_VAL,
       pval031 P_LOS_VAL,
       pval032 P_HRS_WKD_VAL,
       pval033 P_HRS_WKD_BNDRY_PERD_CD,
       pval034 P_AGE_UOM,
       pval035 P_LOS_UOM,
       pval036 P_FRZ_LOS_FLAG,
       pval037 P_FRZ_AGE_FLAG,
       pval038 P_FRZ_CMP_LVL_FLAG,
       pval039 P_FRZ_PCT_FL_TM_FLAG,
       pval040 P_FRZ_HRS_WKD_FLAG,
       pval041 P_FRZ_COMB_AGE_AND_LOS_FLAG,
       pval042 P_OVRID_SVC_DT,
       pval043 P_INELG_RSN_CD,
       pval044 P_ONCE_R_CNTUG_CD,
       pval045 P_OIPL_ORDR_NUM,
       pval046 P_EPO_ATTRIBUTE_CATEGORY,
       pval047 P_EPO_ATTRIBUTE1,
       pval048 P_EPO_ATTRIBUTE2,
       pval049 P_EPO_ATTRIBUTE3,
       pval050 P_EPO_ATTRIBUTE4,
       pval051 P_EPO_ATTRIBUTE5,
       pval052 P_EPO_ATTRIBUTE6,
       pval053 P_EPO_ATTRIBUTE7,
       pval054 P_EPO_ATTRIBUTE8,
       pval055 P_EPO_ATTRIBUTE9,
       pval056 P_EPO_ATTRIBUTE10,
       pval057 P_EPO_ATTRIBUTE11,
       pval058 P_EPO_ATTRIBUTE12,
       pval059 P_EPO_ATTRIBUTE13,
       pval060 P_EPO_ATTRIBUTE14,
       pval061 P_EPO_ATTRIBUTE15,
       pval062 P_EPO_ATTRIBUTE16,
       pval063 P_EPO_ATTRIBUTE17,
       pval064 P_EPO_ATTRIBUTE18,
       pval065 P_EPO_ATTRIBUTE19,
       pval066 P_EPO_ATTRIBUTE20,
       pval067 P_EPO_ATTRIBUTE21,
       pval068 P_EPO_ATTRIBUTE22,
       pval069 P_EPO_ATTRIBUTE23,
       pval070 P_EPO_ATTRIBUTE24,
       pval071 P_EPO_ATTRIBUTE25,
       pval072 P_EPO_ATTRIBUTE26,
       pval073 P_EPO_ATTRIBUTE27,
       pval074 P_EPO_ATTRIBUTE28,
       pval075 P_EPO_ATTRIBUTE29,
       pval076 P_EPO_ATTRIBUTE30,
       pval077 P_PROGRAM_UPDATE_DATE,
       pval078 P_EFFECTIVE_DATE,
       pval079 P_DATETRACK_MODE,
       pval080 P_ELIG_PER_OPT_USER_KEY,
       pval081 P_ELIG_PER_USER_KEY,
       pval082 P_OPTION_DEFINITION,
       pval083 P_PER_IN_LER_USER_KEY,
       pval084 P_RT_COMP_REF_UOM,
       pval085 P_COMP_REF_UOM
from hr_pump_batch_lines
where api_module_id = 385
with check option 

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, BATCH_LINE_ID BATCH_LINE_ID
, API_MODULE_ID API_MODULE_ID
, LINE_STATUS LINE_STATUS
, USER_SEQUENCE USER_SEQUENCE
, LINK_VALUE LINK_VALUE
, BUSINESS_GROUP_NAME BUSINESS_GROUP_NAME
, PVAL001 P_EFFECTIVE_START_DATE
, PVAL002 P_EFFECTIVE_END_DATE
, PVAL003 P_PRTN_OVRIDN_FLAG
, PVAL004 P_PRTN_OVRIDN_THRU_DT
, PVAL005 P_NO_MX_PRTN_OVRID_THRU_FLAG
, PVAL006 P_ELIG_FLAG
, PVAL007 P_PRTN_STRT_DT
, PVAL008 P_PRTN_END_DT
, PVAL009 P_WAIT_PERD_CMPLTN_DATE
, PVAL010 P_WAIT_PERD_STRT_DT
, PVAL011 P_PRTN_OVRIDN_RSN_CD
, PVAL012 P_PCT_FL_TM_VAL
, PVAL013 P_RT_COMP_REF_AMT
, PVAL014 P_RT_CMBN_AGE_N_LOS_VAL
, PVAL015 P_RT_AGE_VAL
, PVAL016 P_RT_LOS_VAL
, PVAL017 P_RT_HRS_WKD_VAL
, PVAL018 P_RT_HRS_WKD_BNDRY_PERD_CD
, PVAL019 P_RT_AGE_UOM
, PVAL020 P_RT_LOS_UOM
, PVAL021 P_RT_PCT_FL_TM_VAL
, PVAL022 P_RT_FRZ_LOS_FLAG
, PVAL023 P_RT_FRZ_AGE_FLAG
, PVAL024 P_RT_FRZ_CMP_LVL_FLAG
, PVAL025 P_RT_FRZ_PCT_FL_TM_FLAG
, PVAL026 P_RT_FRZ_HRS_WKD_FLAG
, PVAL027 P_RT_FRZ_COMB_AGE_AND_LOS_FLAG
, PVAL028 P_COMP_REF_AMT
, PVAL029 P_CMBN_AGE_N_LOS_VAL
, PVAL030 P_AGE_VAL
, PVAL031 P_LOS_VAL
, PVAL032 P_HRS_WKD_VAL
, PVAL033 P_HRS_WKD_BNDRY_PERD_CD
, PVAL034 P_AGE_UOM
, PVAL035 P_LOS_UOM
, PVAL036 P_FRZ_LOS_FLAG
, PVAL037 P_FRZ_AGE_FLAG
, PVAL038 P_FRZ_CMP_LVL_FLAG
, PVAL039 P_FRZ_PCT_FL_TM_FLAG
, PVAL040 P_FRZ_HRS_WKD_FLAG
, PVAL041 P_FRZ_COMB_AGE_AND_LOS_FLAG
, PVAL042 P_OVRID_SVC_DT
, PVAL043 P_INELG_RSN_CD
, PVAL044 P_ONCE_R_CNTUG_CD
, PVAL045 P_OIPL_ORDR_NUM
, PVAL046 P_EPO_ATTRIBUTE_CATEGORY
, PVAL047 P_EPO_ATTRIBUTE1
, PVAL048 P_EPO_ATTRIBUTE2
, PVAL049 P_EPO_ATTRIBUTE3
, PVAL050 P_EPO_ATTRIBUTE4
, PVAL051 P_EPO_ATTRIBUTE5
, PVAL052 P_EPO_ATTRIBUTE6
, PVAL053 P_EPO_ATTRIBUTE7
, PVAL054 P_EPO_ATTRIBUTE8
, PVAL055 P_EPO_ATTRIBUTE9
, PVAL056 P_EPO_ATTRIBUTE10
, PVAL057 P_EPO_ATTRIBUTE11
, PVAL058 P_EPO_ATTRIBUTE12
, PVAL059 P_EPO_ATTRIBUTE13
, PVAL060 P_EPO_ATTRIBUTE14
, PVAL061 P_EPO_ATTRIBUTE15
, PVAL062 P_EPO_ATTRIBUTE16
, PVAL063 P_EPO_ATTRIBUTE17
, PVAL064 P_EPO_ATTRIBUTE18
, PVAL065 P_EPO_ATTRIBUTE19
, PVAL066 P_EPO_ATTRIBUTE20
, PVAL067 P_EPO_ATTRIBUTE21
, PVAL068 P_EPO_ATTRIBUTE22
, PVAL069 P_EPO_ATTRIBUTE23
, PVAL070 P_EPO_ATTRIBUTE24
, PVAL071 P_EPO_ATTRIBUTE25
, PVAL072 P_EPO_ATTRIBUTE26
, PVAL073 P_EPO_ATTRIBUTE27
, PVAL074 P_EPO_ATTRIBUTE28
, PVAL075 P_EPO_ATTRIBUTE29
, PVAL076 P_EPO_ATTRIBUTE30
, PVAL077 P_PROGRAM_UPDATE_DATE
, PVAL078 P_EFFECTIVE_DATE
, PVAL079 P_DATETRACK_MODE
, PVAL080 P_ELIG_PER_OPT_USER_KEY
, PVAL081 P_ELIG_PER_USER_KEY
, PVAL082 P_OPTION_DEFINITION
, PVAL083 P_PER_IN_LER_USER_KEY
, PVAL084 P_RT_COMP_REF_UOM
, PVAL085 P_COMP_REF_UOM FROM HR_PUMP_BATCH_LINES WHERE API_MODULE_ID = 385 WITH CHECK OPTION