[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
enrt_perd_id,
business_group_id,
yr_perd_id,
popl_enrt_typ_cycl_id,
end_dt,
strt_dt,
asnd_lf_evt_dt,
cls_enrt_dt_to_use_cd,
dflt_enrt_dt,
enrt_cvg_strt_dt_cd,
rt_strt_dt_rl,
enrt_cvg_end_dt_cd,
enrt_cvg_strt_dt_rl,
enrt_cvg_end_dt_rl,
procg_end_dt,
rt_strt_dt_cd,
rt_end_dt_cd,
rt_end_dt_rl,
bdgt_upd_strt_dt,
bdgt_upd_end_dt,
ws_upd_strt_dt,
ws_upd_end_dt,
dflt_ws_acc_cd,
prsvr_bdgt_cd,
uses_bdgt_flag,
auto_distr_flag,
hrchy_to_use_cd,
pos_structure_version_id,
emp_interview_type_cd,
wthn_yr_perd_id,
ler_id,
perf_revw_strt_dt,
asg_updt_eff_date,
enp_attribute_category,
enp_attribute1,
enp_attribute2,
enp_attribute3,
enp_attribute4,
enp_attribute5,
enp_attribute6,
enp_attribute7,
enp_attribute8,
enp_attribute9,
enp_attribute10,
enp_attribute11,
enp_attribute12,
enp_attribute13,
enp_attribute14,
enp_attribute15,
enp_attribute16,
enp_attribute17,
enp_attribute18,
enp_attribute19,
enp_attribute20,
enp_attribute21,
enp_attribute22,
enp_attribute23,
enp_attribute24,
enp_attribute25,
enp_attribute26,
enp_attribute27,
enp_attribute28,
enp_attribute29,
enp_attribute30,
enrt_perd_det_ovrlp_bckdt_cd,
--cwb
data_freeze_date ,
Sal_chg_reason_cd,
Approval_mode_cd,
hrchy_ame_trn_cd,
hrchy_rl ,
hrchy_ame_app_id,
---
object_version_number,
reinstate_cd,
reinstate_ovrdn_cd,
defer_deenrol_flag
from ben_enrt_perd
where enrt_perd_id = p_enrt_perd_id;
select enrt_perd_id,
business_group_id,
yr_perd_id,
popl_enrt_typ_cycl_id,
end_dt,
strt_dt,
asnd_lf_evt_Dt,
cls_enrt_dt_to_use_cd,
dflt_enrt_dt,
enrt_cvg_strt_dt_cd,
rt_strt_dt_rl,
enrt_cvg_end_dt_cd,
enrt_cvg_strt_dt_rl,
enrt_cvg_end_dt_rl,
procg_end_dt,
rt_strt_dt_cd,
rt_end_dt_cd,
rt_end_dt_rl,
bdgt_upd_strt_dt,
bdgt_upd_end_dt,
ws_upd_strt_dt,
ws_upd_end_dt,
dflt_ws_acc_cd,
prsvr_bdgt_cd,
uses_bdgt_flag,
auto_distr_flag,
hrchy_to_use_cd,
pos_structure_version_id,
emp_interview_type_cd,
wthn_yr_perd_id,
ler_id,
perf_revw_strt_dt,
asg_updt_eff_date,
enp_attribute_category,
enp_attribute1,
enp_attribute2,
enp_attribute3,
enp_attribute4,
enp_attribute5,
enp_attribute6,
enp_attribute7,
enp_attribute8,
enp_attribute9,
enp_attribute10,
enp_attribute11,
enp_attribute12,
enp_attribute13,
enp_attribute14,
enp_attribute15,
enp_attribute16,
enp_attribute17,
enp_attribute18,
enp_attribute19,
enp_attribute20,
enp_attribute21,
enp_attribute22,
enp_attribute23,
enp_attribute24,
enp_attribute25,
enp_attribute26,
enp_attribute27,
enp_attribute28,
enp_attribute29,
enp_attribute30,
enrt_perd_det_ovrlp_bckdt_cd,
--cwb
data_freeze_date ,
Sal_chg_reason_cd,
Approval_mode_cd,
hrchy_ame_trn_cd,
hrchy_rl ,
hrchy_ame_app_id,
---
object_version_number,
reinstate_cd,
reinstate_ovrdn_cd,
defer_deenrol_flag
from ben_enrt_perd
where enrt_perd_id = p_enrt_perd_id
for update nowait;