[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
pl_id
,lf_evt_ocrd_dt
,oipl_id
,effective_date
,name
,group_pl_id
,group_oipl_id
,opt_hidden_flag
,opt_id
,pl_uom
,pl_ordr_num
,oipl_ordr_num
,pl_xchg_rate
,opt_count
,uses_bdgt_flag
,prsrv_bdgt_cd
,upd_start_dt
,upd_end_dt
,approval_mode
,enrt_perd_start_dt
,enrt_perd_end_dt
,yr_perd_start_dt
,yr_perd_end_dt
,wthn_yr_start_dt
,wthn_yr_end_dt
,enrt_perd_id
,yr_perd_id
,business_group_id
,perf_revw_strt_dt
,asg_updt_eff_date
,emp_interview_typ_cd
,salary_change_reason
,ws_abr_id
,ws_nnmntry_uom
,ws_rndg_cd
,ws_sub_acty_typ_cd
,dist_bdgt_abr_id
,dist_bdgt_nnmntry_uom
,dist_bdgt_rndg_cd
,ws_bdgt_abr_id
,ws_bdgt_nnmntry_uom
,ws_bdgt_rndg_cd
,rsrv_abr_id
,rsrv_nnmntry_uom
,rsrv_rndg_cd
,elig_sal_abr_id
,elig_sal_nnmntry_uom
,elig_sal_rndg_cd
,misc1_abr_id
,misc1_nnmntry_uom
,misc1_rndg_cd
,misc2_abr_id
,misc2_nnmntry_uom
,misc2_rndg_cd
,misc3_abr_id
,misc3_nnmntry_uom
,misc3_rndg_cd
,stat_sal_abr_id
,stat_sal_nnmntry_uom
,stat_sal_rndg_cd
,rec_abr_id
,rec_nnmntry_uom
,rec_rndg_cd
,tot_comp_abr_id
,tot_comp_nnmntry_uom
,tot_comp_rndg_cd
,oth_comp_abr_id
,oth_comp_nnmntry_uom
,oth_comp_rndg_cd
,actual_flag
,acty_ref_perd_cd
,legislation_code
,pl_annulization_factor
,pl_stat_cd
,uom_precision
,ws_element_type_id
,ws_input_value_id
,data_freeze_date
,ws_amt_edit_cd
,ws_amt_edit_enf_cd_for_nulls
,ws_over_budget_edit_cd
,ws_over_budget_tolerance_pct
,bdgt_over_budget_edit_cd
,bdgt_over_budget_tolerance_pct
,auto_distr_flag
,pqh_document_short_name
,ovrid_rt_strt_dt
,do_not_process_flag
,ovr_perf_revw_strt_dt
,object_version_number
from ben_cwb_pl_dsgn
where pl_id = p_pl_id
and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
and oipl_id = p_oipl_id;
select
pl_id
,lf_evt_ocrd_dt
,oipl_id
,effective_date
,name
,group_pl_id
,group_oipl_id
,opt_hidden_flag
,opt_id
,pl_uom
,pl_ordr_num
,oipl_ordr_num
,pl_xchg_rate
,opt_count
,uses_bdgt_flag
,prsrv_bdgt_cd
,upd_start_dt
,upd_end_dt
,approval_mode
,enrt_perd_start_dt
,enrt_perd_end_dt
,yr_perd_start_dt
,yr_perd_end_dt
,wthn_yr_start_dt
,wthn_yr_end_dt
,enrt_perd_id
,yr_perd_id
,business_group_id
,perf_revw_strt_dt
,asg_updt_eff_date
,emp_interview_typ_cd
,salary_change_reason
,ws_abr_id
,ws_nnmntry_uom
,ws_rndg_cd
,ws_sub_acty_typ_cd
,dist_bdgt_abr_id
,dist_bdgt_nnmntry_uom
,dist_bdgt_rndg_cd
,ws_bdgt_abr_id
,ws_bdgt_nnmntry_uom
,ws_bdgt_rndg_cd
,rsrv_abr_id
,rsrv_nnmntry_uom
,rsrv_rndg_cd
,elig_sal_abr_id
,elig_sal_nnmntry_uom
,elig_sal_rndg_cd
,misc1_abr_id
,misc1_nnmntry_uom
,misc1_rndg_cd
,misc2_abr_id
,misc2_nnmntry_uom
,misc2_rndg_cd
,misc3_abr_id
,misc3_nnmntry_uom
,misc3_rndg_cd
,stat_sal_abr_id
,stat_sal_nnmntry_uom
,stat_sal_rndg_cd
,rec_abr_id
,rec_nnmntry_uom
,rec_rndg_cd
,tot_comp_abr_id
,tot_comp_nnmntry_uom
,tot_comp_rndg_cd
,oth_comp_abr_id
,oth_comp_nnmntry_uom
,oth_comp_rndg_cd
,actual_flag
,acty_ref_perd_cd
,legislation_code
,pl_annulization_factor
,pl_stat_cd
,uom_precision
,ws_element_type_id
,ws_input_value_id
,data_freeze_date
,ws_amt_edit_cd
,ws_amt_edit_enf_cd_for_nulls
,ws_over_budget_edit_cd
,ws_over_budget_tolerance_pct
,bdgt_over_budget_edit_cd
,bdgt_over_budget_tolerance_pct
,auto_distr_flag
,pqh_document_short_name
,ovrid_rt_strt_dt
,do_not_process_flag
,ovr_perf_revw_strt_dt
,object_version_number
from ben_cwb_pl_dsgn
where pl_id = p_pl_id
and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
and oipl_id = p_oipl_id
for update nowait;