APPS.BEN_EVALUATE_DPNT_ELG_PROFILES dependencies on BEN_PRTT_ENRT_RSLT_F

Line 2492: ,ben_prtt_enrt_rslt_f pen

2488: --
2489: cursor c_get_elig_cvrd_dpnt(p_pl_id in number) is
2490: select null
2491: from ben_elig_cvrd_dpnt_f pdp
2492: ,ben_prtt_enrt_rslt_f pen
2493: where pdp.dpnt_person_id = p_person_id
2494: and pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
2495: --and pen.prtt_enrt_rslt_stat_cd not in ('VOIDD','BCKDT')
2496: and pen.prtt_enrt_rslt_stat_cd is null

Line 2630: from ben_prtt_enrt_rslt_f pen

2626: and dec.effective_end_date;
2627: --
2628: cursor c_get_prtt_enrt_rslt is
2629: select null
2630: from ben_prtt_enrt_rslt_f pen
2631: where pen.person_id = p_dsgntr_id
2632: and pen.pgm_id = p_pgm_id
2633: --and pen.prtt_enrt_rslt_stat_cd not in ('VOIDD','BCKDT')
2634: and pen.prtt_enrt_rslt_stat_cd is null