DBA Data[Home] [Help]

APPS.BEN_CWB_REFRESH_PKG dependencies on BEN_CWB_PERSON_RATES

Line 46: ,ben_cwb_person_rates rates

42: ,enrt.business_group_id
43: ,rates.object_version_number
44: from
45: ben_cwb_pl_dsgn dsgn
46: ,ben_cwb_person_rates rates
47: ,ben_popl_enrt_typ_cycl_f popl
48: ,ben_cwb_person_info info
49: ,ben_enrt_perd enrt
50: where dsgn.group_pl_id = p_group_pl_id

Line 290: BEN_CWB_PERSON_RATES_API.update_person_rate(

286: hr_utility.set_location(' p_returned_date:'|| l_returned_date, 11);
287: hr_utility.set_location(' p_per_in_ler_id:'|| rec.group_per_in_ler_id, 22);
288: end if;
289:
290: BEN_CWB_PERSON_RATES_API.update_person_rate(
291: p_group_per_in_ler_id => rec.group_per_in_ler_id
292: ,p_pl_id => rec.pl_id
293: ,p_oipl_id => rec.oipl_id
294: ,p_ws_rt_start_date => l_returned_date

Line 300: BEN_CWB_PERSON_RATES_API.update_person_rate(

296: );
297:
298: elsif REC.RT_STRT_DT_CD = 'ENTRBL' then
299:
300: BEN_CWB_PERSON_RATES_API.update_person_rate(
301: p_group_per_in_ler_id => rec.group_per_in_ler_id
302: ,p_pl_id => rec.pl_id
303: ,p_oipl_id => rec.oipl_id
304: ,p_ws_rt_start_date => null