APPS.HRI_OPL_BEN_ELIG_ENRL dependencies on BEN_OPT_F

Line 437: ben_opt_f opt

433: ELSE 0 END) waive_dflt_ind
434: FROM ben_elig_per_elctbl_chc epe,
435: ben_pil_elctbl_chc_popl pel,
436: hri_cs_compobj_ct copd,
437: ben_opt_f opt
438: WHERE epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
439: AND pel.per_in_ler_id = p_pil_rec.per_in_ler_id
440: AND epe.elctbl_flag = 'Y'
441: AND epe.elig_flag = 'Y'

Line 910: ben_opt_f opt,

906: ELSE 0 END ) waive_dflt_ind
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)

Line 1146: ben_opt_f opt

1142: ELSE 0 END) waive_dflt_ind
1143: FROM ben_elig_per_elctbl_chc epe,
1144: ben_pil_elctbl_chc_popl pel,
1145: hri_cs_compobj_ct copd,
1146: ben_opt_f opt
1147: WHERE epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
1148: /* AND pel.per_in_ler_id = p_pil_rec.per_in_ler_id : 4552984 - Perf Fix */
1149: AND EPE.PER_IN_LER_ID = p_pil_rec.per_in_ler_id
1150: AND epe.elctbl_flag = 'Y'

Line 1244: ben_opt_f opt

1240: FROM ben_prtt_enrt_rslt_f pen,
1241: ben_pil_elctbl_chc_popl pel,
1242: hri_cs_compobj_ct copd,
1243: ben_elig_per_elctbl_chc epe,
1244: ben_opt_f opt
1245: WHERE /* pel.per_in_ler_id = p_pil_rec.per_in_ler_id : 4552984 - Perf Fix */
1246: EPE.PER_IN_LER_ID = p_pil_rec.per_in_ler_id
1247: AND pen.per_in_ler_id = pel.per_in_ler_id
1248: AND pen.pgm_id = copd.pgm_id