73:
74: cursor csr_person_ids(p_group_pl_id number
75: ,p_lf_evt_ocrd_dt date) is
76: select distinct(person_id) person_id
77: from ben_cwb_summary
78: where status = 'P'
79: and group_pl_id = p_group_pl_id
80: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
81: --
208: if g_debug then
209: hr_utility.set_location(l_proc, 90);
210: end if;
211: --
212: ben_cwb_summary_pkg.refresh_summary_group_pl
213: (p_group_pl_id => p_group_pl_id
214: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt);
215: --
216: commit;
256: if g_debug then
257: hr_utility.set_location(l_proc, 130);
258: end if;
259: --
260: ben_cwb_summary_pkg.consolidate_summary_rec
261: (p_person_id => rec.person_id);
262: end loop;
263: commit;
264: --