APPS.BEN_CWB_REFRESH_PKG dependencies on BEN_CWB_PERSON_INFO

Line 49: ,ben_cwb_person_info info

45: from
46: ben_cwb_pl_dsgn dsgn
47: ,ben_cwb_person_rates rates
48: ,ben_popl_enrt_typ_cycl_f popl
49: ,ben_cwb_person_info info
50: ,ben_enrt_perd enrt
51: where dsgn.group_pl_id = p_group_pl_id
52: and dsgn.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
53: and info.group_per_in_ler_id = rates.group_per_in_ler_id

Line 188: ben_cwb_person_info_pkg.refresh_person_info_group_pl

184: if g_debug then
185: hr_utility.set_location(l_proc, 60);
186: end if;
187: --
188: ben_cwb_person_info_pkg.refresh_person_info_group_pl
189: (p_group_pl_id => p_group_pl_id
190: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
191: ,p_effective_date => l_effective_date);
192: --

Line 228: UPDATE ben_cwb_person_info

224: if p_refresh_mail_burst_flag = 'Y' then
225: --
226: ben_batch_utils.WRITE('Refreshing Mail Burst Flag');
227: --
228: UPDATE ben_cwb_person_info
229: SET email_status = 'N'
230: WHERE lf_evt_ocrd_dt = trunc(to_date(p_lf_evt_ocrd_dt,'yyyy/mm/dd hh24:mi:ss'))
231: AND p_group_pl_id = group_pl_id;
232: --