APPS.BEN_MANAGE_CWB_LIFE_EVENTS dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 1809: from ben_pil_elctbl_chc_popl pel

1805: --
1806: cursor c_popl(cv_per_in_ler_id number) is
1807: select pel.pil_elctbl_chc_popl_id,
1808: pel.object_version_number pel_ovn
1809: from ben_pil_elctbl_chc_popl pel
1810: where pel.per_in_ler_id = cv_per_in_ler_id;
1811: --
1812: l_popl_rec c_popl%rowtype;
1813: --

Line 1879: * ben_per_in_ler, ben_ptnl_ler_for_per, ben_pil_elctbl_chc_popl,

1875: * ELIG_FLAG = Y and only consider uncloned data
1876: * then
1877: *
1878: * Delete data from ben_cwb_person_rates, ben_cwb_person_groups,
1879: * ben_per_in_ler, ben_ptnl_ler_for_per, ben_pil_elctbl_chc_popl,
1880: * ben_elig_per_elctbl_chc, ben_group_heirarchy,
1881: * ben_cwb_person_tasks.
1882: */
1883: if g_debug then

Line 1914: ben_Pil_Elctbl_chc_Popl_api.delete_Pil_Elctbl_chc_Popl

1910: p_effective_date => p_group_lf_evt_ocrd_dt);
1911: --
1912: end loop;
1913: --
1914: ben_Pil_Elctbl_chc_Popl_api.delete_Pil_Elctbl_chc_Popl
1915: (p_pil_elctbl_chc_popl_id => l_popl_rec.pil_elctbl_chc_popl_id,
1916: p_object_version_number => l_popl_rec.pel_ovn,
1917: p_effective_date => p_group_lf_evt_ocrd_dt);
1918: --