APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 2836: FROM ben_elig_per_elctbl_chc epe

2832: --
2833: --
2834: CURSOR c_choice_exists_for_option IS
2835: SELECT NULL
2836: FROM ben_elig_per_elctbl_chc epe
2837: WHERE epe.oipl_id = p_oipl_id
2838: -- added 9/25/98 to handle plans in mult progs
2839: AND (
2840: ( epe.pgm_id = p_pgm_id

Line 2852: FROM ben_elig_per_elctbl_chc epe

2848: --
2849: --
2850: CURSOR c_choice_exists_for_plan(pp_pl_id NUMBER) IS
2851: SELECT elig_per_elctbl_chc_id
2852: FROM ben_elig_per_elctbl_chc epe
2853: WHERE epe.pl_id = pp_pl_id
2854: AND epe.oipl_id IS NULL
2855: -- added 9/25/98 to handle plans in mult progs
2856: AND (

Line 3660: from ben_elig_per_elctbl_chc epe,

3656: --
3657: cursor c_hrchy(cv_emp_epe_id number) is
3658: select hrc.emp_pil_elctbl_chc_popl_id,
3659: pel.pil_elctbl_chc_popl_id
3660: from ben_elig_per_elctbl_chc epe,
3661: ben_pil_elctbl_chc_popl pel,
3662: ben_cwb_hrchy hrc
3663: where pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
3664: and epe.elig_per_elctbl_chc_id = cv_emp_epe_id

Line 9729: from ben_elig_per_elctbl_chc epe,

9725: epe.dflt_flag,
9726: epe.ELCTBL_FLAG,
9727: epe.ELIG_PER_ELCTBL_CHC_ID,
9728: epe.OBJECT_VERSION_NUMBER
9729: from ben_elig_per_elctbl_chc epe,
9730: /*
9731: ben_per_in_ler pil,
9732: */
9733: ben_pl_f pln