APPS.BEN_CLOSE_ENROLLMENT dependencies on BEN_PRTT_ENRT_RSLT_F

Line 547: from ben_prtt_enrt_rslt_f pen

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

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

2509: where epe.per_in_ler_id = cv_per_in_ler_id
2510: and epe.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id
2511: and epe.prtt_enrt_rslt_id IS NOT NULL
2512: and enb.prtt_enrt_rslt_id IS NULL
2513: and exists ( select 'x' from ben_prtt_enrt_rslt_f pen
2514: where pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id
2515: and pen.bnft_ordr_num = enb.ordr_num
2516: and pen.prtt_enrt_rslt_stat_cd is NULL
2517: and pen.per_in_ler_id = epe.per_in_ler_id ) ;