eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRI_OPL_BEN_ELIG_ENRL dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 375: FROM ben_elig_per_elctbl_chc epe,

371: AND epe.dflt_flag = 'Y'
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

Line 434: FROM ben_elig_per_elctbl_chc epe,

430: AND epe.dflt_flag = 'Y'
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

Line 1084: FROM ben_elig_per_elctbl_chc epe,

1080: AND epe.dflt_flag = 'Y'
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

Line 1143: FROM ben_elig_per_elctbl_chc epe,

1139: AND epe.dflt_flag = 'Y'
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

Line 1172: SELECT /+ INDEX(epe BEN_ELIG_PER_ELCTBL_CHC_N5) /

1168: AND pen.effective_start_date = pel.enrt_perd_strt_dt))
1169: UNION ALL
1170: -- The 3rd and 4th UNIONs.. returns all Enrollment Results.
1171: -- 3rd Union gets all PLIPs and OIPL IS NULL
1172: SELECT /*+ INDEX(epe BEN_ELIG_PER_ELCTBL_CHC_N5) */
1173: pen.effective_start_date change_date,
1174: copd.compobj_sk_pk compobj_sk_pk,
1175: pel.enrt_perd_id,
1176: pen.prtt_enrt_rslt_id prtt_enrt_rslt_id,

Line 1198: ben_elig_per_elctbl_chc epe,

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
1201: AND pen.per_in_ler_id = pel.per_in_ler_id
1202: AND pen.pgm_id = copd.pgm_id

Line 1217: SELECT /+ INDEX(epe BEN_ELIG_PER_ELCTBL_CHC_N5) /

1213: AND p_pil_rec.lf_evt_ocrd_dt BETWEEN pln.effective_start_date
1214: AND pln.effective_end_date
1215: UNION ALL
1216: -- 4th Union gets all OIPLs
1217: SELECT /*+ INDEX(epe BEN_ELIG_PER_ELCTBL_CHC_N5) */
1218: pen.effective_start_date change_date,
1219: copd.compobj_sk_pk compobj_sk_pk,
1220: pel.enrt_perd_id,
1221: pen.prtt_enrt_rslt_id prtt_enrt_rslt_id,

Line 1243: ben_elig_per_elctbl_chc epe,

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 */
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