APPS.BEN_PRTT_RT_VAL_API dependencies on BEN_PRTT_ENRT_RSLT_F

Line 28: from ben_prtt_enrt_rslt_f pen

24: l_proc varchar2(72); -- := g_package||'result_is_suspended';
25: --
26: cursor c_result is
27: select nvl(sspndd_flag,'N')
28: from ben_prtt_enrt_rslt_f pen
29: where prtt_enrt_rslt_id=p_prtt_enrt_rslt_id and
30: pen.prtt_enrt_rslt_stat_cd is null and
31: business_group_id=p_business_group_id and
32: p_effective_date <= effective_end_date

Line 300: ben_prtt_enrt_rslt_f pen

296: --
297: cursor c_pl_nip is
298: select null
299: from ben_pl_f pln,
300: ben_prtt_enrt_rslt_f pen
301: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
302: and pen.prtt_enrt_rslt_stat_cd is null
303: and pen.pl_id = pln.pl_id
304: and pln.pl_cd = 'MYNTBPGM'

Line 907: from ben_prtt_enrt_rslt_f pen

903: -- 12583091
904: --
905: cursor c_pen_curr(p_prtt_enrt_rslt_id number) is
906: select pen.*
907: from ben_prtt_enrt_rslt_f pen
908: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
909: and pen.effective_end_date = hr_api.g_eot
910: and pen.prtt_enrt_rslt_stat_cd is null
911: and pen.business_group_id = p_business_group_id;