APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 2805: FROM ben_elig_per_elctbl_chc epe

2801: --
2802: --
2803: CURSOR c_choice_exists_for_option IS
2804: SELECT NULL
2805: FROM ben_elig_per_elctbl_chc epe
2806: WHERE epe.oipl_id = p_oipl_id
2807: -- added 9/25/98 to handle plans in mult progs
2808: AND (
2809: ( epe.pgm_id = p_pgm_id

Line 2821: FROM ben_elig_per_elctbl_chc epe

2817: --
2818: --
2819: CURSOR c_choice_exists_for_plan(pp_pl_id NUMBER) IS
2820: SELECT elig_per_elctbl_chc_id
2821: FROM ben_elig_per_elctbl_chc epe
2822: WHERE epe.pl_id = pp_pl_id
2823: AND epe.oipl_id IS NULL
2824: -- added 9/25/98 to handle plans in mult progs
2825: AND (

Line 3614: from ben_elig_per_elctbl_chc epe,

3610: --
3611: cursor c_hrchy(cv_emp_epe_id number) is
3612: select hrc.emp_pil_elctbl_chc_popl_id,
3613: pel.pil_elctbl_chc_popl_id
3614: from ben_elig_per_elctbl_chc epe,
3615: ben_pil_elctbl_chc_popl pel,
3616: ben_cwb_hrchy hrc
3617: where pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
3618: and epe.elig_per_elctbl_chc_id = cv_emp_epe_id

Line 9587: from ben_elig_per_elctbl_chc epe,

9583: epe.dflt_flag,
9584: epe.ELCTBL_FLAG,
9585: epe.ELIG_PER_ELCTBL_CHC_ID,
9586: epe.OBJECT_VERSION_NUMBER
9587: from ben_elig_per_elctbl_chc epe,
9588: /*
9589: ben_per_in_ler pil,
9590: */
9591: ben_pl_f pln