APPS.HRI_OPL_BEN_ELIG_ENRL dependencies on BEN_PL_F

Line 378: ben_pl_f pln

374: ELSE 0 END) waive_dflt_ind
375: FROM ben_elig_per_elctbl_chc epe,
376: ben_pil_elctbl_chc_popl pel,
377: hri_cs_compobj_ct copd,
378: ben_pl_f pln
379: WHERE epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
380: AND pel.per_in_ler_id = p_pil_rec.per_in_ler_id
381: AND epe.elctbl_flag = 'Y'
382: AND epe.elig_flag = 'Y'

Line 911: ben_pl_f pln

907: FROM HRI_EQ_BEN_ELIGENRL_EVTS penq,
908: hri_cs_time_benrl_prd_ct enpd,
909: hri_cs_compobj_ct copd,
910: ben_opt_f opt,
911: ben_pl_f pln
912: WHERE penq.per_in_ler_id = p_per_in_ler_id
913: AND penq.event_cd IN ('ENRD') --,'DE-ENRD')
914: AND opt.opt_id(+) = NVL(copd.opt_id,-1)
915: AND pln.pl_id = copd.pl_id

Line 1087: ben_pl_f pln

1083: ELSE 0 END) waive_dflt_ind
1084: FROM ben_elig_per_elctbl_chc epe,
1085: ben_pil_elctbl_chc_popl pel,
1086: hri_cs_compobj_ct copd,
1087: ben_pl_f pln
1088: WHERE epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
1089: AND pel.per_in_ler_id = p_pil_rec.per_in_ler_id
1090: AND epe.elctbl_flag = 'Y'
1091: AND epe.elig_flag = 'Y'

Line 1199: ben_pl_f pln

1195: FROM ben_prtt_enrt_rslt_f pen,
1196: ben_pil_elctbl_chc_popl pel,
1197: hri_cs_compobj_ct copd,
1198: ben_elig_per_elctbl_chc epe,
1199: ben_pl_f pln
1200: WHERE pel.per_in_ler_id = p_pil_rec.per_in_ler_id
1201: AND pen.per_in_ler_id = pel.per_in_ler_id
1202: AND pen.pgm_id = copd.pgm_id
1203: AND pen.pgm_id = pel.pgm_id