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_PRTT_ENRT_RESULT

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_PRTT_ENRT_RSLT_USER_KEY,
       pval002 P_EFFECTIVE_START_DATE,
       pval003 P_EFFECTIVE_END_DATE,
       pval004 P_SSPNDD_FLAG,
       pval005 P_PRTT_IS_CVRD_FLAG,
       pval006 P_BNFT_AMT,
       pval007 P_ORGNL_ENRT_DT,
       pval008 P_ENRT_MTHD_CD,
       pval009 P_NO_LNGR_ELIG_FLAG,
       pval010 P_ENRT_OVRIDN_FLAG,
       pval011 P_ENRT_OVRID_RSN_CD,
       pval012 P_ERLST_DEENRT_DT,
       pval013 P_ENRT_CVG_STRT_DT,
       pval014 P_ENRT_CVG_THRU_DT,
       pval015 P_ENRT_OVRID_THRU_DT,
       pval016 P_PL_ORDR_NUM,
       pval017 P_PLIP_ORDR_NUM,
       pval018 P_PTIP_ORDR_NUM,
       pval019 P_OIPL_ORDR_NUM,
       pval020 P_PEN_ATTRIBUTE_CATEGORY,
       pval021 P_PEN_ATTRIBUTE1,
       pval022 P_PEN_ATTRIBUTE2,
       pval023 P_PEN_ATTRIBUTE3,
       pval024 P_PEN_ATTRIBUTE4,
       pval025 P_PEN_ATTRIBUTE5,
       pval026 P_PEN_ATTRIBUTE6,
       pval027 P_PEN_ATTRIBUTE7,
       pval028 P_PEN_ATTRIBUTE8,
       pval029 P_PEN_ATTRIBUTE9,
       pval030 P_PEN_ATTRIBUTE10,
       pval031 P_PEN_ATTRIBUTE11,
       pval032 P_PEN_ATTRIBUTE12,
       pval033 P_PEN_ATTRIBUTE13,
       pval034 P_PEN_ATTRIBUTE14,
       pval035 P_PEN_ATTRIBUTE15,
       pval036 P_PEN_ATTRIBUTE16,
       pval037 P_PEN_ATTRIBUTE17,
       pval038 P_PEN_ATTRIBUTE18,
       pval039 P_PEN_ATTRIBUTE19,
       pval040 P_PEN_ATTRIBUTE20,
       pval041 P_PEN_ATTRIBUTE21,
       pval042 P_PEN_ATTRIBUTE22,
       pval043 P_PEN_ATTRIBUTE23,
       pval044 P_PEN_ATTRIBUTE24,
       pval045 P_PEN_ATTRIBUTE25,
       pval046 P_PEN_ATTRIBUTE26,
       pval047 P_PEN_ATTRIBUTE27,
       pval048 P_PEN_ATTRIBUTE28,
       pval049 P_PEN_ATTRIBUTE29,
       pval050 P_PEN_ATTRIBUTE30,
       pval051 P_PROGRAM_UPDATE_DATE,
       pval052 P_OBJECT_VERSION_NUMBER,
       pval053 P_BNFT_TYP_CD,
       pval054 P_BNFT_ORDR_NUM,
       pval055 P_PRTT_ENRT_RSLT_STAT_CD,
       pval056 P_BNFT_NNMNTRY_UOM,
       pval057 P_COMP_LVL_CD,
       pval058 P_EFFECTIVE_DATE,
       pval059 P_MULTI_ROW_VALIDATE,
       pval060 P_OIPL_USER_KEY,
       pval061 P_PERSON_USER_KEY,
       pval062 P_ASSIGNMENT_USER_KEY,
       pval063 P_PROGRAM,
       pval064 P_PLAN,
       pval065 P_RPLCS_SSPNDD_RSLT_USER_KEY,
       pval066 P_PTIP_USER_KEY,
       pval067 P_PLAN_TYPE,
       pval068 P_LIFE_EVENT_REASON,
       pval069 P_UOM,
       pval070 P_PER_IN_LER_USER_KEY
from hr_pump_batch_lines
where api_module_id = 617
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_PRTT_ENRT_RSLT_USER_KEY
, PVAL002 P_EFFECTIVE_START_DATE
, PVAL003 P_EFFECTIVE_END_DATE
, PVAL004 P_SSPNDD_FLAG
, PVAL005 P_PRTT_IS_CVRD_FLAG
, PVAL006 P_BNFT_AMT
, PVAL007 P_ORGNL_ENRT_DT
, PVAL008 P_ENRT_MTHD_CD
, PVAL009 P_NO_LNGR_ELIG_FLAG
, PVAL010 P_ENRT_OVRIDN_FLAG
, PVAL011 P_ENRT_OVRID_RSN_CD
, PVAL012 P_ERLST_DEENRT_DT
, PVAL013 P_ENRT_CVG_STRT_DT
, PVAL014 P_ENRT_CVG_THRU_DT
, PVAL015 P_ENRT_OVRID_THRU_DT
, PVAL016 P_PL_ORDR_NUM
, PVAL017 P_PLIP_ORDR_NUM
, PVAL018 P_PTIP_ORDR_NUM
, PVAL019 P_OIPL_ORDR_NUM
, PVAL020 P_PEN_ATTRIBUTE_CATEGORY
, PVAL021 P_PEN_ATTRIBUTE1
, PVAL022 P_PEN_ATTRIBUTE2
, PVAL023 P_PEN_ATTRIBUTE3
, PVAL024 P_PEN_ATTRIBUTE4
, PVAL025 P_PEN_ATTRIBUTE5
, PVAL026 P_PEN_ATTRIBUTE6
, PVAL027 P_PEN_ATTRIBUTE7
, PVAL028 P_PEN_ATTRIBUTE8
, PVAL029 P_PEN_ATTRIBUTE9
, PVAL030 P_PEN_ATTRIBUTE10
, PVAL031 P_PEN_ATTRIBUTE11
, PVAL032 P_PEN_ATTRIBUTE12
, PVAL033 P_PEN_ATTRIBUTE13
, PVAL034 P_PEN_ATTRIBUTE14
, PVAL035 P_PEN_ATTRIBUTE15
, PVAL036 P_PEN_ATTRIBUTE16
, PVAL037 P_PEN_ATTRIBUTE17
, PVAL038 P_PEN_ATTRIBUTE18
, PVAL039 P_PEN_ATTRIBUTE19
, PVAL040 P_PEN_ATTRIBUTE20
, PVAL041 P_PEN_ATTRIBUTE21
, PVAL042 P_PEN_ATTRIBUTE22
, PVAL043 P_PEN_ATTRIBUTE23
, PVAL044 P_PEN_ATTRIBUTE24
, PVAL045 P_PEN_ATTRIBUTE25
, PVAL046 P_PEN_ATTRIBUTE26
, PVAL047 P_PEN_ATTRIBUTE27
, PVAL048 P_PEN_ATTRIBUTE28
, PVAL049 P_PEN_ATTRIBUTE29
, PVAL050 P_PEN_ATTRIBUTE30
, PVAL051 P_PROGRAM_UPDATE_DATE
, PVAL052 P_OBJECT_VERSION_NUMBER
, PVAL053 P_BNFT_TYP_CD
, PVAL054 P_BNFT_ORDR_NUM
, PVAL055 P_PRTT_ENRT_RSLT_STAT_CD
, PVAL056 P_BNFT_NNMNTRY_UOM
, PVAL057 P_COMP_LVL_CD
, PVAL058 P_EFFECTIVE_DATE
, PVAL059 P_MULTI_ROW_VALIDATE
, PVAL060 P_OIPL_USER_KEY
, PVAL061 P_PERSON_USER_KEY
, PVAL062 P_ASSIGNMENT_USER_KEY
, PVAL063 P_PROGRAM
, PVAL064 P_PLAN
, PVAL065 P_RPLCS_SSPNDD_RSLT_USER_KEY
, PVAL066 P_PTIP_USER_KEY
, PVAL067 P_PLAN_TYPE
, PVAL068 P_LIFE_EVENT_REASON
, PVAL069 P_UOM
, PVAL070 P_PER_IN_LER_USER_KEY FROM HR_PUMP_BATCH_LINES WHERE API_MODULE_ID = 617 WITH CHECK OPTION