APPS.BEN_EVALUATE_DPNT_ELG_PROFILES dependencies on BEN_PRTT_ENRT_RSLT_F

Line 2459: ,ben_prtt_enrt_rslt_f pen

2455: --
2456: cursor c_get_elig_cvrd_dpnt(p_pl_id in number) is
2457: select null
2458: from ben_elig_cvrd_dpnt_f pdp
2459: ,ben_prtt_enrt_rslt_f pen
2460: where pdp.dpnt_person_id = p_person_id
2461: and pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
2462: --and pen.prtt_enrt_rslt_stat_cd not in ('VOIDD','BCKDT')
2463: and pen.prtt_enrt_rslt_stat_cd is null

Line 2597: from ben_prtt_enrt_rslt_f pen

2593: and dec.effective_end_date;
2594: --
2595: cursor c_get_prtt_enrt_rslt is
2596: select null
2597: from ben_prtt_enrt_rslt_f pen
2598: where pen.person_id = p_dsgntr_id
2599: and pen.pgm_id = p_pgm_id
2600: --and pen.prtt_enrt_rslt_stat_cd not in ('VOIDD','BCKDT')
2601: and pen.prtt_enrt_rslt_stat_cd is null