APPS.BEN_CLOSE_ENROLLMENT dependencies on BEN_PRTT_ENRT_RSLT_F

Line 548: from ben_prtt_enrt_rslt_f pen

544: pl_id,
545: oipl_id,
546: object_version_number,
547: ler_id
548: from ben_prtt_enrt_rslt_f pen
549: where pen.per_in_ler_id = p_per_in_ler_id
550: and pen.no_lngr_elig_flag = 'Y'
551: and nvl(pen.enrt_cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
552: and pen.effective_end_date = hr_api.g_eot

Line 2553: and exists ( select 'x' from ben_prtt_enrt_rslt_f pen

2549: where epe.per_in_ler_id = cv_per_in_ler_id
2550: and epe.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id
2551: and epe.prtt_enrt_rslt_id IS NOT NULL
2552: and enb.prtt_enrt_rslt_id IS NULL
2553: and exists ( select 'x' from ben_prtt_enrt_rslt_f pen
2554: where pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
2555: and pen.bnft_ordr_num = enb.ordr_num
2556: and pen.prtt_enrt_rslt_stat_cd is NULL
2557: and pen.per_in_ler_id = epe.per_in_ler_id ) ;