APPS.BEN_MANAGE_CWB_LIFE_EVENTS dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 1818: from ben_elig_per_elctbl_chc epe

1814: cursor c_epe(cv_per_in_ler_id number,
1815: cv_pil_elctbl_chc_popl_id number) is
1816: select epe.elig_per_elctbl_chc_id,
1817: epe.object_version_number epe_ovn
1818: from ben_elig_per_elctbl_chc epe
1819: where epe.per_in_ler_id = cv_per_in_ler_id
1820: and cv_pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id;
1821: --
1822: cursor c_pln(cv_effective_date date) is

Line 1880: * ben_elig_per_elctbl_chc, ben_group_heirarchy,

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
1884: l_package := g_package||'.del_all_cwb_pils';

Line 3386: from ben_elig_per_elctbl_chc

3382: and opt.effective_end_date;
3383: --
3384: cursor c_epe(cv_elig_per_elctbl_chc_id in number) is
3385: select elig_flag, inelig_rsn_cd
3386: from ben_elig_per_elctbl_chc
3387: where elig_per_elctbl_chc_id = cv_elig_per_elctbl_chc_id;
3388: --
3389: l_oipl_id number;
3390: l_group_oipl_id number;