VIEW: APPS.HRDPV_UPDATE_PERSON_LIFE_EVENT

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_PER_IN_LER_STAT_CD,
       pval002 P_PRVS_STAT_CD,
       pval003 P_LF_EVT_OCRD_DT,
       pval004 P_PROCD_DT,
       pval005 P_STRTD_DT,
       pval006 P_VOIDD_DT,
       pval007 P_BCKT_DT,
       pval008 P_CLSD_DT,
       pval009 P_NTFN_DT,
       pval010 P_MGR_OVRID_DT,
       pval011 P_PIL_ATTRIBUTE_CATEGORY,
       pval012 P_PIL_ATTRIBUTE1,
       pval013 P_PIL_ATTRIBUTE2,
       pval014 P_PIL_ATTRIBUTE3,
       pval015 P_PIL_ATTRIBUTE4,
       pval016 P_PIL_ATTRIBUTE5,
       pval017 P_PIL_ATTRIBUTE6,
       pval018 P_PIL_ATTRIBUTE7,
       pval019 P_PIL_ATTRIBUTE8,
       pval020 P_PIL_ATTRIBUTE9,
       pval021 P_PIL_ATTRIBUTE10,
       pval022 P_PIL_ATTRIBUTE11,
       pval023 P_PIL_ATTRIBUTE12,
       pval024 P_PIL_ATTRIBUTE13,
       pval025 P_PIL_ATTRIBUTE14,
       pval026 P_PIL_ATTRIBUTE15,
       pval027 P_PIL_ATTRIBUTE16,
       pval028 P_PIL_ATTRIBUTE17,
       pval029 P_PIL_ATTRIBUTE18,
       pval030 P_PIL_ATTRIBUTE19,
       pval031 P_PIL_ATTRIBUTE20,
       pval032 P_PIL_ATTRIBUTE21,
       pval033 P_PIL_ATTRIBUTE22,
       pval034 P_PIL_ATTRIBUTE23,
       pval035 P_PIL_ATTRIBUTE24,
       pval036 P_PIL_ATTRIBUTE25,
       pval037 P_PIL_ATTRIBUTE26,
       pval038 P_PIL_ATTRIBUTE27,
       pval039 P_PIL_ATTRIBUTE28,
       pval040 P_PIL_ATTRIBUTE29,
       pval041 P_PIL_ATTRIBUTE30,
       pval042 P_PROGRAM_UPDATE_DATE,
       pval043 P_EFFECTIVE_DATE,
       pval044 P_PER_IN_LER_USER_KEY,
       pval045 P_TRGR_TABLE_PK_USER_KEY,
       pval046 P_PTNL_LER_FOR_PER_USER_KEY,
       pval047 P_BCKT_PER_IN_LER_USER_KEY,
       pval048 P_LIFE_EVENT_REASON,
       pval049 P_PERSON_USER_KEY,
       pval050 P_ASSIGNMENT_USER_KEY,
       pval051 P_WS_MGR_USER_KEY,
       pval052 P_GROUP_PL_USER_KEY,
       pval053 P_MGR_OVRID_PERSON_USER_KEY
from hr_pump_batch_lines
where api_module_id = 652
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_PER_IN_LER_STAT_CD
, PVAL002 P_PRVS_STAT_CD
, PVAL003 P_LF_EVT_OCRD_DT
, PVAL004 P_PROCD_DT
, PVAL005 P_STRTD_DT
, PVAL006 P_VOIDD_DT
, PVAL007 P_BCKT_DT
, PVAL008 P_CLSD_DT
, PVAL009 P_NTFN_DT
, PVAL010 P_MGR_OVRID_DT
, PVAL011 P_PIL_ATTRIBUTE_CATEGORY
, PVAL012 P_PIL_ATTRIBUTE1
, PVAL013 P_PIL_ATTRIBUTE2
, PVAL014 P_PIL_ATTRIBUTE3
, PVAL015 P_PIL_ATTRIBUTE4
, PVAL016 P_PIL_ATTRIBUTE5
, PVAL017 P_PIL_ATTRIBUTE6
, PVAL018 P_PIL_ATTRIBUTE7
, PVAL019 P_PIL_ATTRIBUTE8
, PVAL020 P_PIL_ATTRIBUTE9
, PVAL021 P_PIL_ATTRIBUTE10
, PVAL022 P_PIL_ATTRIBUTE11
, PVAL023 P_PIL_ATTRIBUTE12
, PVAL024 P_PIL_ATTRIBUTE13
, PVAL025 P_PIL_ATTRIBUTE14
, PVAL026 P_PIL_ATTRIBUTE15
, PVAL027 P_PIL_ATTRIBUTE16
, PVAL028 P_PIL_ATTRIBUTE17
, PVAL029 P_PIL_ATTRIBUTE18
, PVAL030 P_PIL_ATTRIBUTE19
, PVAL031 P_PIL_ATTRIBUTE20
, PVAL032 P_PIL_ATTRIBUTE21
, PVAL033 P_PIL_ATTRIBUTE22
, PVAL034 P_PIL_ATTRIBUTE23
, PVAL035 P_PIL_ATTRIBUTE24
, PVAL036 P_PIL_ATTRIBUTE25
, PVAL037 P_PIL_ATTRIBUTE26
, PVAL038 P_PIL_ATTRIBUTE27
, PVAL039 P_PIL_ATTRIBUTE28
, PVAL040 P_PIL_ATTRIBUTE29
, PVAL041 P_PIL_ATTRIBUTE30
, PVAL042 P_PROGRAM_UPDATE_DATE
, PVAL043 P_EFFECTIVE_DATE
, PVAL044 P_PER_IN_LER_USER_KEY
, PVAL045 P_TRGR_TABLE_PK_USER_KEY
, PVAL046 P_PTNL_LER_FOR_PER_USER_KEY
, PVAL047 P_BCKT_PER_IN_LER_USER_KEY
, PVAL048 P_LIFE_EVENT_REASON
, PVAL049 P_PERSON_USER_KEY
, PVAL050 P_ASSIGNMENT_USER_KEY
, PVAL051 P_WS_MGR_USER_KEY
, PVAL052 P_GROUP_PL_USER_KEY
, PVAL053 P_MGR_OVRID_PERSON_USER_KEY FROM HR_PUMP_BATCH_LINES WHERE API_MODULE_ID = 652 WITH CHECK OPTION