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 299: ben_prtt_enrt_rslt_f pen

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