[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select max(Hrchy.emp_per_in_ler_id) GrpLerId,
max(Grp.group_pl_id) GrpPlId,
max(Grp.group_oipl_id) GrpOiplId,
max(Grp.object_version_number) Ovn
From ben_cwb_group_hrchy Hrchy,
ben_cwb_person_groups Grp,
ben_cwb_summary Summ
Where Hrchy.mgr_per_in_ler_id = c_group_per_in_ler_id
and Hrchy.lvl_num > 0
and Grp.group_per_in_ler_id = Hrchy.emp_per_in_ler_id
and Grp.group_pl_id = c_group_pl_id
and Grp.lf_evt_ocrd_dt = c_lf_evt_ocrd_dt
and Summ.group_per_in_ler_id = Grp.group_per_in_ler_id
and Summ.group_pl_id = Grp.group_pl_id
and Summ.group_oipl_id = Grp.group_oipl_id
and Summ.lf_evt_ocrd_dt = Grp.lf_evt_ocrd_dt
Group by Summ.group_per_in_ler_id,
Summ.group_pl_id,
Summ.group_oipl_id
having sum(Summ.elig_count_all) > 0
and (max(dist_bdgt_val) is not null or max(ws_bdgt_val) is not null or
max(dist_bdgt_iss_val) is not null or max(ws_bdgt_iss_val) is not null)
Order by GrpLerId;
ben_cwb_person_groups_api.update_group_budget
(p_group_per_in_ler_id => Pop.GrpLerId
,p_group_pl_id => Pop.GrpPlId
,p_group_oipl_id => Pop.GrpOiplId
,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_date
,p_dist_bdgt_val => null
,p_ws_bdgt_val => null
,p_dist_bdgt_iss_val => null
,p_ws_bdgt_iss_val => null
,p_ws_bdgt_iss_date => null
,p_dist_bdgt_iss_date => null
,p_bdgt_pop_cd => null
,p_ws_bdgt_val_last_upd_date => l_effective_date
,p_ws_bdgt_val_last_upd_by => p_logon_person_id
,p_dist_bdgt_val_last_upd_date=> l_effective_date
,p_dist_bdgt_val_last_upd_by => p_logon_person_id
,p_object_version_number => Pop.Ovn
);