APPS.BEN_PRTT_ENRT_CTFN_PRVDD_API dependencies on BEN_PRTT_ENRT_RSLT_F

Line 29: from ben_prtt_enrt_rslt_f pen,

25: pea.cmpltd_dt,
26: pea.rqd_flag,
27: pen.object_version_number rslt_ovn,
28: pea.object_version_number
29: from ben_prtt_enrt_rslt_f pen,
30: ben_prtt_enrt_actn_f pea
31: where pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
32: and pea.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
33: and pea.business_group_id = p_business_group_id

Line 138: from ben_prtt_enrt_rslt_f pen

134: --
135: cursor c_sspndd_rslt is
136: select pen.object_version_number,
137: pen.effective_start_date,pen.per_in_ler_id -- 2386000
138: from ben_prtt_enrt_rslt_f pen
139: where p_prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
140: and pen.business_group_id = p_business_group_id
141: and pen.prtt_enrt_rslt_stat_cd is null
142: and p_effective_date

Line 998: ben_prtt_enrt_rslt_f pen

994: select pea.object_version_number,
995: pea.prtt_enrt_rslt_id,
996: pen.object_version_number
997: from ben_prtt_enrt_actn_f pea,
998: ben_prtt_enrt_rslt_f pen
999: where pea.prtt_enrt_actn_id = l_prtt_enrt_actn_id
1000: and pea.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1001: and pen.prtt_enrt_rslt_stat_cd is null
1002: and p_effective_date between pea.effective_start_date