APPS.BEN_PRV_BUS dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 977: from ben_elig_per_elctbl_chc epe, ben_per_in_ler pil

973: where enb.enrt_bnft_id = p_enrt_bnft_id;
974:
975: cursor c3 (p_elig_per_elctbl_chc_id number) is
976: select pil.person_id
977: from ben_elig_per_elctbl_chc epe, ben_per_in_ler pil
978: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
979: and epe.per_in_ler_id = pil.per_in_ler_id;
980: l_c3 c3%rowtype;
981:

Line 997: from ben_elig_per_elctbl_chc epe,

993: cursor c_pln
994: (c_elig_per_elctbl_chc_id in number )
995: is
996: select pln.name || ' '|| opt.name
997: from ben_elig_per_elctbl_chc epe,
998: ben_pl_f pln,
999: ben_oipl_f oipl,
1000: ben_opt_f opt
1001: where epe.elig_per_elctbl_chc_id =c_elig_per_elctbl_chc_id

Line 1255: from ben_elig_per_elctbl_chc epe,

1251: cursor c_pln
1252: (c_elig_per_elctbl_chc_id in number )
1253: is
1254: select pln.name || ' '|| opt.name
1255: from ben_elig_per_elctbl_chc epe,
1256: ben_pl_f pln,
1257: ben_oipl_f oipl,
1258: ben_opt_f opt
1259: where epe.elig_per_elctbl_chc_id =c_elig_per_elctbl_chc_id