VIEW: APPS.HRDPV_CREATE_PTNL_LER_FOR_PER

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_PTNL_LER_FOR_PER_USER_KEY,
       pval002 P_LF_EVT_OCRD_DT,
       pval003 P_PTNL_LER_FOR_PER_STAT_CD,
       pval004 P_PTNL_LER_FOR_PER_SRC_CD,
       pval005 P_MNL_DT,
       pval006 P_DTCTD_DT,
       pval007 P_PROCD_DT,
       pval008 P_UNPROCD_DT,
       pval009 P_VOIDD_DT,
       pval010 P_MNLO_DT,
       pval011 P_NTFN_DT,
       pval012 P_PROGRAM_UPDATE_DATE,
       pval013 P_OBJECT_VERSION_NUMBER,
       pval014 P_EFFECTIVE_DATE,
       pval015 P_CSD_BY_PPL_USER_KEY,
       pval016 P_TRGR_TABLE_PK_USER_KEY,
       pval017 P_ENRT_PERD_USER_KEY,
       pval018 P_LIFE_EVENT_REASON,
       pval019 P_PERSON_USER_KEY
from hr_pump_batch_lines
where api_module_id = 660
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_PTNL_LER_FOR_PER_USER_KEY
, PVAL002 P_LF_EVT_OCRD_DT
, PVAL003 P_PTNL_LER_FOR_PER_STAT_CD
, PVAL004 P_PTNL_LER_FOR_PER_SRC_CD
, PVAL005 P_MNL_DT
, PVAL006 P_DTCTD_DT
, PVAL007 P_PROCD_DT
, PVAL008 P_UNPROCD_DT
, PVAL009 P_VOIDD_DT
, PVAL010 P_MNLO_DT
, PVAL011 P_NTFN_DT
, PVAL012 P_PROGRAM_UPDATE_DATE
, PVAL013 P_OBJECT_VERSION_NUMBER
, PVAL014 P_EFFECTIVE_DATE
, PVAL015 P_CSD_BY_PPL_USER_KEY
, PVAL016 P_TRGR_TABLE_PK_USER_KEY
, PVAL017 P_ENRT_PERD_USER_KEY
, PVAL018 P_LIFE_EVENT_REASON
, PVAL019 P_PERSON_USER_KEY FROM HR_PUMP_BATCH_LINES WHERE API_MODULE_ID = 660 WITH CHECK OPTION