APPS.HRI_OPL_BEN_ELIG_ENRL dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 376: ben_pil_elctbl_chc_popl pel,

372: AND pln.invk_dcln_prtn_pl_flag = 'Y')
373: THEN 1
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

Line 435: ben_pil_elctbl_chc_popl pel,

431: AND opt.invk_wv_opt_flag = 'Y')
432: THEN 1
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

Line 550: FROM ben_pil_elctbl_chc_popl pel,

546: ,pel.enrt_perd_id enrt_perd_id
547: ,pil.per_in_ler_id per_in_ler_id
548: ,pel.pgm_id pgm_id
549: ,pel.pil_elctbl_chc_popl_id pil_elctbl_chc_popl_id
550: FROM ben_pil_elctbl_chc_popl pel,
551: ben_per_in_ler pil,
552: ben_ptnl_ler_for_per ppl
553: WHERE pel.per_in_ler_id = pil.per_in_ler_id
554: AND ppl.ptnl_ler_for_per_id = pil.ptnl_ler_for_per_id

Line 1085: ben_pil_elctbl_chc_popl pel,

1081: AND pln.invk_dcln_prtn_pl_flag = 'Y')
1082: THEN 1
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

Line 1144: ben_pil_elctbl_chc_popl pel,

1140: AND opt.invk_wv_opt_flag = 'Y')
1141: THEN 1
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 */

Line 1196: ben_pil_elctbl_chc_popl pel,

1192: AND pln.invk_dcln_prtn_pl_flag = 'Y')
1193: THEN 1
1194: ELSE 0 END) waive_dflt_ind
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

Line 1241: ben_pil_elctbl_chc_popl pel,

1237: AND opt.invk_wv_opt_flag = 'Y' )
1238: THEN 1
1239: ELSE 0 END) waive_dflt_ind
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 */