eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.HRDPV_CREATE_ELIGIBLE_PERSON

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_ELIG_PER_USER_KEY,
       pval002 P_EFFECTIVE_START_DATE,
       pval003 P_EFFECTIVE_END_DATE,
       pval004 P_PER_IN_LER_ID,
       pval005 P_DPNT_OTHR_PL_CVRD_RL_FLAG,
       pval006 P_PRTN_OVRIDN_THRU_DT,
       pval007 P_PL_KEY_EE_FLAG,
       pval008 P_PL_HGHLY_COMPD_FLAG,
       pval009 P_ELIG_FLAG,
       pval010 P_COMP_REF_AMT,
       pval011 P_CMBN_AGE_N_LOS_VAL,
       pval012 P_AGE_VAL,
       pval013 P_LOS_VAL,
       pval014 P_PRTN_END_DT,
       pval015 P_PRTN_STRT_DT,
       pval016 P_WAIT_PERD_CMPLTN_DT,
       pval017 P_WAIT_PERD_STRT_DT,
       pval018 P_WV_CTFN_TYP_CD,
       pval019 P_HRS_WKD_VAL,
       pval020 P_HRS_WKD_BNDRY_PERD_CD,
       pval021 P_PRTN_OVRIDN_FLAG,
       pval022 P_NO_MX_PRTN_OVRID_THRU_FLAG,
       pval023 P_PRTN_OVRIDN_RSN_CD,
       pval024 P_AGE_UOM,
       pval025 P_LOS_UOM,
       pval026 P_OVRID_SVC_DT,
       pval027 P_INELG_RSN_CD,
       pval028 P_FRZ_LOS_FLAG,
       pval029 P_FRZ_AGE_FLAG,
       pval030 P_FRZ_CMP_LVL_FLAG,
       pval031 P_FRZ_PCT_FL_TM_FLAG,
       pval032 P_FRZ_HRS_WKD_FLAG,
       pval033 P_FRZ_COMB_AGE_AND_LOS_FLAG,
       pval034 P_DSTR_RSTCN_FLAG,
       pval035 P_PCT_FL_TM_VAL,
       pval036 P_WV_PRTN_RSN_CD,
       pval037 P_PL_WVD_FLAG,
       pval038 P_RT_COMP_REF_AMT,
       pval039 P_RT_CMBN_AGE_N_LOS_VAL,
       pval040 P_RT_AGE_VAL,
       pval041 P_RT_LOS_VAL,
       pval042 P_RT_HRS_WKD_VAL,
       pval043 P_RT_HRS_WKD_BNDRY_PERD_CD,
       pval044 P_RT_AGE_UOM,
       pval045 P_RT_LOS_UOM,
       pval046 P_RT_PCT_FL_TM_VAL,
       pval047 P_RT_FRZ_LOS_FLAG,
       pval048 P_RT_FRZ_AGE_FLAG,
       pval049 P_RT_FRZ_CMP_LVL_FLAG,
       pval050 P_RT_FRZ_PCT_FL_TM_FLAG,
       pval051 P_RT_FRZ_HRS_WKD_FLAG,
       pval052 P_RT_FRZ_COMB_AGE_AND_LOS_FLAG,
       pval053 P_ONCE_R_CNTUG_CD,
       pval054 P_PL_ORDR_NUM,
       pval055 P_PLIP_ORDR_NUM,
       pval056 P_PTIP_ORDR_NUM,
       pval057 P_PEP_ATTRIBUTE_CATEGORY,
       pval058 P_PEP_ATTRIBUTE1,
       pval059 P_PEP_ATTRIBUTE2,
       pval060 P_PEP_ATTRIBUTE3,
       pval061 P_PEP_ATTRIBUTE4,
       pval062 P_PEP_ATTRIBUTE5,
       pval063 P_PEP_ATTRIBUTE6,
       pval064 P_PEP_ATTRIBUTE7,
       pval065 P_PEP_ATTRIBUTE8,
       pval066 P_PEP_ATTRIBUTE9,
       pval067 P_PEP_ATTRIBUTE10,
       pval068 P_PEP_ATTRIBUTE11,
       pval069 P_PEP_ATTRIBUTE12,
       pval070 P_PEP_ATTRIBUTE13,
       pval071 P_PEP_ATTRIBUTE14,
       pval072 P_PEP_ATTRIBUTE15,
       pval073 P_PEP_ATTRIBUTE16,
       pval074 P_PEP_ATTRIBUTE17,
       pval075 P_PEP_ATTRIBUTE18,
       pval076 P_PEP_ATTRIBUTE19,
       pval077 P_PEP_ATTRIBUTE20,
       pval078 P_PEP_ATTRIBUTE21,
       pval079 P_PEP_ATTRIBUTE22,
       pval080 P_PEP_ATTRIBUTE23,
       pval081 P_PEP_ATTRIBUTE24,
       pval082 P_PEP_ATTRIBUTE25,
       pval083 P_PEP_ATTRIBUTE26,
       pval084 P_PEP_ATTRIBUTE27,
       pval085 P_PEP_ATTRIBUTE28,
       pval086 P_PEP_ATTRIBUTE29,
       pval087 P_PEP_ATTRIBUTE30,
       pval088 P_PROGRAM_UPDATE_DATE,
       pval089 P_OBJECT_VERSION_NUMBER,
       pval090 P_EFFECTIVE_DATE,
       pval091 P_OVERRIDE_VALIDATION,
       pval092 P_PLAN,
       pval093 P_PROGRAM,
       pval094 P_PLIP_USER_KEY,
       pval095 P_PTIP_USER_KEY,
       pval096 P_LIFE_EVENT_REASON,
       pval097 P_PERSON_USER_KEY,
       pval098 P_COMP_REF_UOM,
       pval099 P_RT_COMP_REF_UOM
from hr_pump_batch_lines
where api_module_id = 625
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_ELIG_PER_USER_KEY
, PVAL002 P_EFFECTIVE_START_DATE
, PVAL003 P_EFFECTIVE_END_DATE
, PVAL004 P_PER_IN_LER_ID
, PVAL005 P_DPNT_OTHR_PL_CVRD_RL_FLAG
, PVAL006 P_PRTN_OVRIDN_THRU_DT
, PVAL007 P_PL_KEY_EE_FLAG
, PVAL008 P_PL_HGHLY_COMPD_FLAG
, PVAL009 P_ELIG_FLAG
, PVAL010 P_COMP_REF_AMT
, PVAL011 P_CMBN_AGE_N_LOS_VAL
, PVAL012 P_AGE_VAL
, PVAL013 P_LOS_VAL
, PVAL014 P_PRTN_END_DT
, PVAL015 P_PRTN_STRT_DT
, PVAL016 P_WAIT_PERD_CMPLTN_DT
, PVAL017 P_WAIT_PERD_STRT_DT
, PVAL018 P_WV_CTFN_TYP_CD
, PVAL019 P_HRS_WKD_VAL
, PVAL020 P_HRS_WKD_BNDRY_PERD_CD
, PVAL021 P_PRTN_OVRIDN_FLAG
, PVAL022 P_NO_MX_PRTN_OVRID_THRU_FLAG
, PVAL023 P_PRTN_OVRIDN_RSN_CD
, PVAL024 P_AGE_UOM
, PVAL025 P_LOS_UOM
, PVAL026 P_OVRID_SVC_DT
, PVAL027 P_INELG_RSN_CD
, PVAL028 P_FRZ_LOS_FLAG
, PVAL029 P_FRZ_AGE_FLAG
, PVAL030 P_FRZ_CMP_LVL_FLAG
, PVAL031 P_FRZ_PCT_FL_TM_FLAG
, PVAL032 P_FRZ_HRS_WKD_FLAG
, PVAL033 P_FRZ_COMB_AGE_AND_LOS_FLAG
, PVAL034 P_DSTR_RSTCN_FLAG
, PVAL035 P_PCT_FL_TM_VAL
, PVAL036 P_WV_PRTN_RSN_CD
, PVAL037 P_PL_WVD_FLAG
, PVAL038 P_RT_COMP_REF_AMT
, PVAL039 P_RT_CMBN_AGE_N_LOS_VAL
, PVAL040 P_RT_AGE_VAL
, PVAL041 P_RT_LOS_VAL
, PVAL042 P_RT_HRS_WKD_VAL
, PVAL043 P_RT_HRS_WKD_BNDRY_PERD_CD
, PVAL044 P_RT_AGE_UOM
, PVAL045 P_RT_LOS_UOM
, PVAL046 P_RT_PCT_FL_TM_VAL
, PVAL047 P_RT_FRZ_LOS_FLAG
, PVAL048 P_RT_FRZ_AGE_FLAG
, PVAL049 P_RT_FRZ_CMP_LVL_FLAG
, PVAL050 P_RT_FRZ_PCT_FL_TM_FLAG
, PVAL051 P_RT_FRZ_HRS_WKD_FLAG
, PVAL052 P_RT_FRZ_COMB_AGE_AND_LOS_FLAG
, PVAL053 P_ONCE_R_CNTUG_CD
, PVAL054 P_PL_ORDR_NUM
, PVAL055 P_PLIP_ORDR_NUM
, PVAL056 P_PTIP_ORDR_NUM
, PVAL057 P_PEP_ATTRIBUTE_CATEGORY
, PVAL058 P_PEP_ATTRIBUTE1
, PVAL059 P_PEP_ATTRIBUTE2
, PVAL060 P_PEP_ATTRIBUTE3
, PVAL061 P_PEP_ATTRIBUTE4
, PVAL062 P_PEP_ATTRIBUTE5
, PVAL063 P_PEP_ATTRIBUTE6
, PVAL064 P_PEP_ATTRIBUTE7
, PVAL065 P_PEP_ATTRIBUTE8
, PVAL066 P_PEP_ATTRIBUTE9
, PVAL067 P_PEP_ATTRIBUTE10
, PVAL068 P_PEP_ATTRIBUTE11
, PVAL069 P_PEP_ATTRIBUTE12
, PVAL070 P_PEP_ATTRIBUTE13
, PVAL071 P_PEP_ATTRIBUTE14
, PVAL072 P_PEP_ATTRIBUTE15
, PVAL073 P_PEP_ATTRIBUTE16
, PVAL074 P_PEP_ATTRIBUTE17
, PVAL075 P_PEP_ATTRIBUTE18
, PVAL076 P_PEP_ATTRIBUTE19
, PVAL077 P_PEP_ATTRIBUTE20
, PVAL078 P_PEP_ATTRIBUTE21
, PVAL079 P_PEP_ATTRIBUTE22
, PVAL080 P_PEP_ATTRIBUTE23
, PVAL081 P_PEP_ATTRIBUTE24
, PVAL082 P_PEP_ATTRIBUTE25
, PVAL083 P_PEP_ATTRIBUTE26
, PVAL084 P_PEP_ATTRIBUTE27
, PVAL085 P_PEP_ATTRIBUTE28
, PVAL086 P_PEP_ATTRIBUTE29
, PVAL087 P_PEP_ATTRIBUTE30
, PVAL088 P_PROGRAM_UPDATE_DATE
, PVAL089 P_OBJECT_VERSION_NUMBER
, PVAL090 P_EFFECTIVE_DATE
, PVAL091 P_OVERRIDE_VALIDATION
, PVAL092 P_PLAN
, PVAL093 P_PROGRAM
, PVAL094 P_PLIP_USER_KEY
, PVAL095 P_PTIP_USER_KEY
, PVAL096 P_LIFE_EVENT_REASON
, PVAL097 P_PERSON_USER_KEY
, PVAL098 P_COMP_REF_UOM
, PVAL099 P_RT_COMP_REF_UOM FROM HR_PUMP_BATCH_LINES WHERE API_MODULE_ID = 625 WITH CHECK OPTION