VIEW: APPS.HRDPV_CREATE_PRTT_RT_VAL

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_RT_VAL_USER_KEY,
       pval002 P_RT_STRT_DT,
       pval003 P_RT_END_DT,
       pval004 P_RT_TYP_CD,
       pval005 P_TX_TYP_CD,
       pval006 P_ORDR_NUM,
       pval007 P_ACTY_TYP_CD,
       pval008 P_MLT_CD,
       pval009 P_ACTY_REF_PERD_CD,
       pval010 P_RT_VAL,
       pval011 P_ANN_RT_VAL,
       pval012 P_CMCD_RT_VAL,
       pval013 P_CMCD_REF_PERD_CD,
       pval014 P_BNFT_RT_TYP_CD,
       pval015 P_DSPLY_ON_ENRT_FLAG,
       pval016 P_RT_OVRIDN_FLAG,
       pval017 P_RT_OVRIDN_THRU_DT,
       pval018 P_ELCTNS_MADE_DT,
       pval019 P_PRTT_RT_VAL_STAT_CD,
       pval020 P_ELEMENT_ENTRY_VALUE_ID,
       pval021 P_PRTT_RMT_APRVD_FR_PYMT_ID,
       pval022 P_PP_IN_YR_USED_NUM,
       pval023 P_PRV_ATTRIBUTE_CATEGORY,
       pval024 P_PRV_ATTRIBUTE1,
       pval025 P_PRV_ATTRIBUTE2,
       pval026 P_PRV_ATTRIBUTE3,
       pval027 P_PRV_ATTRIBUTE4,
       pval028 P_PRV_ATTRIBUTE5,
       pval029 P_PRV_ATTRIBUTE6,
       pval030 P_PRV_ATTRIBUTE7,
       pval031 P_PRV_ATTRIBUTE8,
       pval032 P_PRV_ATTRIBUTE9,
       pval033 P_PRV_ATTRIBUTE10,
       pval034 P_PRV_ATTRIBUTE11,
       pval035 P_PRV_ATTRIBUTE12,
       pval036 P_PRV_ATTRIBUTE13,
       pval037 P_PRV_ATTRIBUTE14,
       pval038 P_PRV_ATTRIBUTE15,
       pval039 P_PRV_ATTRIBUTE16,
       pval040 P_PRV_ATTRIBUTE17,
       pval041 P_PRV_ATTRIBUTE18,
       pval042 P_PRV_ATTRIBUTE19,
       pval043 P_PRV_ATTRIBUTE20,
       pval044 P_PRV_ATTRIBUTE21,
       pval045 P_PRV_ATTRIBUTE22,
       pval046 P_PRV_ATTRIBUTE23,
       pval047 P_PRV_ATTRIBUTE24,
       pval048 P_PRV_ATTRIBUTE25,
       pval049 P_PRV_ATTRIBUTE26,
       pval050 P_PRV_ATTRIBUTE27,
       pval051 P_PRV_ATTRIBUTE28,
       pval052 P_PRV_ATTRIBUTE29,
       pval053 P_PRV_ATTRIBUTE30,
       pval054 P_PK_ID_TABLE_NAME,
       pval055 P_PK_ID,
       pval056 P_OBJECT_VERSION_NUMBER,
       pval057 P_EFFECTIVE_DATE,
       pval058 P_ENRT_RT_USER_KEY,
       pval059 P_PERSON_USER_KEY,
       pval060 P_INPUT_VALUE_NAME,
       pval061 P_ELEMENT_NAME,
       pval062 P_LANGUAGE_CODE,
       pval063 P_PRTT_ENRT_RSLT_USER_KEY,
       pval064 P_CVG_AMT_CALC,
       pval065 P_ACTUAL_PREMIUM,
       pval066 P_COMP_LEVEL_FACTOR,
       pval067 P_PER_IN_LER_USER_KEY,
       pval068 P_ENDED_PER_IN_LER_USER_KEY,
       pval069 P_ACTY_BASE_RATE,
       pval070 P_PRTT_REIMBMT_RQST_USER_KEY
from hr_pump_batch_lines
where api_module_id = 697
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_RT_VAL_USER_KEY
, PVAL002 P_RT_STRT_DT
, PVAL003 P_RT_END_DT
, PVAL004 P_RT_TYP_CD
, PVAL005 P_TX_TYP_CD
, PVAL006 P_ORDR_NUM
, PVAL007 P_ACTY_TYP_CD
, PVAL008 P_MLT_CD
, PVAL009 P_ACTY_REF_PERD_CD
, PVAL010 P_RT_VAL
, PVAL011 P_ANN_RT_VAL
, PVAL012 P_CMCD_RT_VAL
, PVAL013 P_CMCD_REF_PERD_CD
, PVAL014 P_BNFT_RT_TYP_CD
, PVAL015 P_DSPLY_ON_ENRT_FLAG
, PVAL016 P_RT_OVRIDN_FLAG
, PVAL017 P_RT_OVRIDN_THRU_DT
, PVAL018 P_ELCTNS_MADE_DT
, PVAL019 P_PRTT_RT_VAL_STAT_CD
, PVAL020 P_ELEMENT_ENTRY_VALUE_ID
, PVAL021 P_PRTT_RMT_APRVD_FR_PYMT_ID
, PVAL022 P_PP_IN_YR_USED_NUM
, PVAL023 P_PRV_ATTRIBUTE_CATEGORY
, PVAL024 P_PRV_ATTRIBUTE1
, PVAL025 P_PRV_ATTRIBUTE2
, PVAL026 P_PRV_ATTRIBUTE3
, PVAL027 P_PRV_ATTRIBUTE4
, PVAL028 P_PRV_ATTRIBUTE5
, PVAL029 P_PRV_ATTRIBUTE6
, PVAL030 P_PRV_ATTRIBUTE7
, PVAL031 P_PRV_ATTRIBUTE8
, PVAL032 P_PRV_ATTRIBUTE9
, PVAL033 P_PRV_ATTRIBUTE10
, PVAL034 P_PRV_ATTRIBUTE11
, PVAL035 P_PRV_ATTRIBUTE12
, PVAL036 P_PRV_ATTRIBUTE13
, PVAL037 P_PRV_ATTRIBUTE14
, PVAL038 P_PRV_ATTRIBUTE15
, PVAL039 P_PRV_ATTRIBUTE16
, PVAL040 P_PRV_ATTRIBUTE17
, PVAL041 P_PRV_ATTRIBUTE18
, PVAL042 P_PRV_ATTRIBUTE19
, PVAL043 P_PRV_ATTRIBUTE20
, PVAL044 P_PRV_ATTRIBUTE21
, PVAL045 P_PRV_ATTRIBUTE22
, PVAL046 P_PRV_ATTRIBUTE23
, PVAL047 P_PRV_ATTRIBUTE24
, PVAL048 P_PRV_ATTRIBUTE25
, PVAL049 P_PRV_ATTRIBUTE26
, PVAL050 P_PRV_ATTRIBUTE27
, PVAL051 P_PRV_ATTRIBUTE28
, PVAL052 P_PRV_ATTRIBUTE29
, PVAL053 P_PRV_ATTRIBUTE30
, PVAL054 P_PK_ID_TABLE_NAME
, PVAL055 P_PK_ID
, PVAL056 P_OBJECT_VERSION_NUMBER
, PVAL057 P_EFFECTIVE_DATE
, PVAL058 P_ENRT_RT_USER_KEY
, PVAL059 P_PERSON_USER_KEY
, PVAL060 P_INPUT_VALUE_NAME
, PVAL061 P_ELEMENT_NAME
, PVAL062 P_LANGUAGE_CODE
, PVAL063 P_PRTT_ENRT_RSLT_USER_KEY
, PVAL064 P_CVG_AMT_CALC
, PVAL065 P_ACTUAL_PREMIUM
, PVAL066 P_COMP_LEVEL_FACTOR
, PVAL067 P_PER_IN_LER_USER_KEY
, PVAL068 P_ENDED_PER_IN_LER_USER_KEY
, PVAL069 P_ACTY_BASE_RATE
, PVAL070 P_PRTT_REIMBMT_RQST_USER_KEY FROM HR_PUMP_BATCH_LINES WHERE API_MODULE_ID = 697 WITH CHECK OPTION