APPS.HRI_OPL_BEN_ELIG_ENRL dependencies on BEN_PRTT_ENRT_RSLT_F

Line 394: FROM ben_prtt_enrt_rslt_f pen

390: AND pln.effective_end_date
391: AND (epe.prtt_enrt_rslt_id IS NULL
392: OR NOT EXISTS (
393: SELECT null
394: FROM ben_prtt_enrt_rslt_f pen
395: WHERE pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
396: AND pen.per_in_ler_id = p_pil_rec.per_in_ler_id
397: AND pen.prtt_enrt_rslt_stat_cd IS NULL
398: AND pen.enrt_cvg_thru_dt = hr_api.g_eot

Line 452: FROM ben_prtt_enrt_rslt_f pen

448: AND opt.effective_end_date
449: AND (epe.prtt_enrt_rslt_id IS NULL
450: OR NOT EXISTS (
451: SELECT null
452: FROM ben_prtt_enrt_rslt_f pen
453: WHERE pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
454: AND pen.per_in_ler_id = p_pil_rec.per_in_ler_id
455: AND pen.prtt_enrt_rslt_stat_cd IS NULL
456: AND pen.enrt_cvg_thru_dt = hr_api.g_eot

Line 1103: FROM ben_prtt_enrt_rslt_f pen

1099: AND pln.effective_end_date
1100: AND (epe.prtt_enrt_rslt_id IS NULL
1101: OR NOT EXISTS (
1102: SELECT null
1103: FROM ben_prtt_enrt_rslt_f pen
1104: WHERE pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
1105: AND pen.per_in_ler_Id = p_pil_rec.per_in_ler_id
1106: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1107: AND pen.enrt_cvg_thru_dt = hr_api.g_eot

Line 1162: FROM ben_prtt_enrt_rslt_f pen

1158: AND opt.effective_end_date
1159: AND (epe.prtt_enrt_rslt_id IS NULL
1160: OR NOT EXISTS (
1161: SELECT null
1162: FROM ben_prtt_enrt_rslt_f pen
1163: WHERE pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
1164: AND pen.per_in_ler_Id = p_pil_rec.per_in_ler_id
1165: AND pen.prtt_enrt_rslt_stat_cd IS NULL
1166: AND pen.enrt_cvg_thru_dt = hr_api.g_eot

Line 1195: FROM ben_prtt_enrt_rslt_f pen,

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

Line 1240: FROM ben_prtt_enrt_rslt_f pen,

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