APPS.BEN_MANAGE_CWB_LIFE_EVENTS dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 1773: from ben_elig_per_elctbl_chc epe

1769: cursor c_epe(cv_per_in_ler_id number,
1770: cv_pil_elctbl_chc_popl_id number) is
1771: select epe.elig_per_elctbl_chc_id,
1772: epe.object_version_number epe_ovn
1773: from ben_elig_per_elctbl_chc epe
1774: where epe.per_in_ler_id = cv_per_in_ler_id
1775: and cv_pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id;
1776: --
1777: cursor c_pln(cv_effective_date date) is

Line 1835: * ben_elig_per_elctbl_chc, ben_group_heirarchy,

1831: * then
1832: *
1833: * Delete data from ben_cwb_person_rates, ben_cwb_person_groups,
1834: * ben_per_in_ler, ben_ptnl_ler_for_per, ben_pil_elctbl_chc_popl,
1835: * ben_elig_per_elctbl_chc, ben_group_heirarchy,
1836: * ben_cwb_person_tasks.
1837: */
1838: if g_debug then
1839: l_package := g_package||'.del_all_cwb_pils';

Line 3334: from ben_elig_per_elctbl_chc

3330: and opt.effective_end_date;
3331: --
3332: cursor c_epe(cv_elig_per_elctbl_chc_id in number) is
3333: select elig_flag, inelig_rsn_cd
3334: from ben_elig_per_elctbl_chc
3335: where elig_per_elctbl_chc_id = cv_elig_per_elctbl_chc_id;
3336: --
3337: l_oipl_id number;
3338: l_group_oipl_id number;