APPS.BEN_PRTT_ENRT_RESULT_API dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 1723: from ben_pil_elctbl_chc_popl pel

1719: --
1720: /* Start of Changes for Bug: 1646442: added cursor */
1721: cursor c_pel (p_elig_pe_elctbl_chc_id number) is
1722: select pel.enrt_perd_id,pel.lee_rsn_id
1723: from ben_pil_elctbl_chc_popl pel
1724: ,ben_elig_per_elctbl_chc epe
1725: where pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
1726: and epe.elig_per_elctbl_chc_id = p_elig_pe_elctbl_chc_id;
1727: --

Line 3280: from ben_pil_elctbl_chc_popl pel

3276: --
3277: /* Start of Changes for WWBUG: 1646442: added */
3278: cursor c_pel (p_elig_pe_elctbl_chc_id number) is
3279: select pel.enrt_perd_id,pel.lee_rsn_id
3280: from ben_pil_elctbl_chc_popl pel
3281: ,ben_elig_per_elctbl_chc epe
3282: where pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
3283: and epe.elig_per_elctbl_chc_id = p_elig_pe_elctbl_chc_id;
3284:

Line 6824: from ben_pil_elctbl_chc_popl pel

6820: l_pen_ovn c_pen_ovn%rowtype;
6821: --
6822: cursor c_pel (p_elig_pe_elctbl_chc_id number) is
6823: select pel.enrt_perd_id,pel.lee_rsn_id
6824: from ben_pil_elctbl_chc_popl pel
6825: ,ben_elig_per_elctbl_chc epe
6826: where pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
6827: and epe.elig_per_elctbl_chc_id = p_elig_pe_elctbl_chc_id;
6828: --

Line 11699: ,ben_pil_elctbl_chc_popl pel

11695: ,r.enrt_mthd_cd
11696: From ben_prtt_enrt_rslt_f r
11697: ,ben_elig_per_elctbl_chc c
11698: ,ben_oipl_f oipl
11699: ,ben_pil_elctbl_chc_popl pel
11700: Where c.per_in_ler_id = p_per_in_ler_id
11701: and r.prtt_enrt_rslt_id = c.prtt_enrt_rslt_id
11702: and r.per_in_ler_id <> c.per_in_ler_id
11703: and r.person_id = p_person_id

Line 11778: from ben_pil_elctbl_chc_popl pel,

11774: -- For plan not in program (p_pgm_id is null)
11775: --
11776: cursor pl_typ_c is
11777: select distinct pln.pl_typ_id
11778: from ben_pil_elctbl_chc_popl pel,
11779: ben_pl_f pln
11780: where pel.per_in_ler_id = p_per_in_ler_id
11781: and pel.pgm_id is null
11782: and (pel.elcns_made_dt is not null or pel.dflt_asnd_dt is not NULL)