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_PLAN_BENEFICIARY

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_PL_BNF_USER_KEY,
       pval002 P_EFFECTIVE_START_DATE,
       pval003 P_EFFECTIVE_END_DATE,
       pval004 P_PRMRY_CNTNGNT_CD,
       pval005 P_PCT_DSGD_NUM,
       pval006 P_AMT_DSGD_VAL,
       pval007 P_DSGN_STRT_DT,
       pval008 P_DSGN_THRU_DT,
       pval009 P_ADDL_INSTRN_TXT,
       pval010 P_PBN_ATTRIBUTE_CATEGORY,
       pval011 P_PBN_ATTRIBUTE1,
       pval012 P_PBN_ATTRIBUTE2,
       pval013 P_PBN_ATTRIBUTE3,
       pval014 P_PBN_ATTRIBUTE4,
       pval015 P_PBN_ATTRIBUTE5,
       pval016 P_PBN_ATTRIBUTE6,
       pval017 P_PBN_ATTRIBUTE7,
       pval018 P_PBN_ATTRIBUTE8,
       pval019 P_PBN_ATTRIBUTE9,
       pval020 P_PBN_ATTRIBUTE10,
       pval021 P_PBN_ATTRIBUTE11,
       pval022 P_PBN_ATTRIBUTE12,
       pval023 P_PBN_ATTRIBUTE13,
       pval024 P_PBN_ATTRIBUTE14,
       pval025 P_PBN_ATTRIBUTE15,
       pval026 P_PBN_ATTRIBUTE16,
       pval027 P_PBN_ATTRIBUTE17,
       pval028 P_PBN_ATTRIBUTE18,
       pval029 P_PBN_ATTRIBUTE19,
       pval030 P_PBN_ATTRIBUTE20,
       pval031 P_PBN_ATTRIBUTE21,
       pval032 P_PBN_ATTRIBUTE22,
       pval033 P_PBN_ATTRIBUTE23,
       pval034 P_PBN_ATTRIBUTE24,
       pval035 P_PBN_ATTRIBUTE25,
       pval036 P_PBN_ATTRIBUTE26,
       pval037 P_PBN_ATTRIBUTE27,
       pval038 P_PBN_ATTRIBUTE28,
       pval039 P_PBN_ATTRIBUTE29,
       pval040 P_PBN_ATTRIBUTE30,
       pval041 P_PROGRAM_UPDATE_DATE,
       pval042 P_OBJECT_VERSION_NUMBER,
       pval043 P_EFFECTIVE_DATE,
       pval044 P_MULTI_ROW_ACTN,
       pval045 P_PRTT_ENRT_RSLT_USER_KEY,
       pval046 P_BNF_PERSON_USER_KEY,
       pval047 P_ORGANIZATION_NAME,
       pval048 P_LANGUAGE_CODE,
       pval049 P_TTEE_PERSON_USER_KEY,
       pval050 P_AMT_DSGD_UOM,
       pval051 P_PER_IN_LER_USER_KEY
from hr_pump_batch_lines
where api_module_id = 563
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_PL_BNF_USER_KEY
, PVAL002 P_EFFECTIVE_START_DATE
, PVAL003 P_EFFECTIVE_END_DATE
, PVAL004 P_PRMRY_CNTNGNT_CD
, PVAL005 P_PCT_DSGD_NUM
, PVAL006 P_AMT_DSGD_VAL
, PVAL007 P_DSGN_STRT_DT
, PVAL008 P_DSGN_THRU_DT
, PVAL009 P_ADDL_INSTRN_TXT
, PVAL010 P_PBN_ATTRIBUTE_CATEGORY
, PVAL011 P_PBN_ATTRIBUTE1
, PVAL012 P_PBN_ATTRIBUTE2
, PVAL013 P_PBN_ATTRIBUTE3
, PVAL014 P_PBN_ATTRIBUTE4
, PVAL015 P_PBN_ATTRIBUTE5
, PVAL016 P_PBN_ATTRIBUTE6
, PVAL017 P_PBN_ATTRIBUTE7
, PVAL018 P_PBN_ATTRIBUTE8
, PVAL019 P_PBN_ATTRIBUTE9
, PVAL020 P_PBN_ATTRIBUTE10
, PVAL021 P_PBN_ATTRIBUTE11
, PVAL022 P_PBN_ATTRIBUTE12
, PVAL023 P_PBN_ATTRIBUTE13
, PVAL024 P_PBN_ATTRIBUTE14
, PVAL025 P_PBN_ATTRIBUTE15
, PVAL026 P_PBN_ATTRIBUTE16
, PVAL027 P_PBN_ATTRIBUTE17
, PVAL028 P_PBN_ATTRIBUTE18
, PVAL029 P_PBN_ATTRIBUTE19
, PVAL030 P_PBN_ATTRIBUTE20
, PVAL031 P_PBN_ATTRIBUTE21
, PVAL032 P_PBN_ATTRIBUTE22
, PVAL033 P_PBN_ATTRIBUTE23
, PVAL034 P_PBN_ATTRIBUTE24
, PVAL035 P_PBN_ATTRIBUTE25
, PVAL036 P_PBN_ATTRIBUTE26
, PVAL037 P_PBN_ATTRIBUTE27
, PVAL038 P_PBN_ATTRIBUTE28
, PVAL039 P_PBN_ATTRIBUTE29
, PVAL040 P_PBN_ATTRIBUTE30
, PVAL041 P_PROGRAM_UPDATE_DATE
, PVAL042 P_OBJECT_VERSION_NUMBER
, PVAL043 P_EFFECTIVE_DATE
, PVAL044 P_MULTI_ROW_ACTN
, PVAL045 P_PRTT_ENRT_RSLT_USER_KEY
, PVAL046 P_BNF_PERSON_USER_KEY
, PVAL047 P_ORGANIZATION_NAME
, PVAL048 P_LANGUAGE_CODE
, PVAL049 P_TTEE_PERSON_USER_KEY
, PVAL050 P_AMT_DSGD_UOM
, PVAL051 P_PER_IN_LER_USER_KEY FROM HR_PUMP_BATCH_LINES WHERE API_MODULE_ID = 563 WITH CHECK OPTION