APPS.BEN_PL_BNF_CTFN_PRVDD_API dependencies on BEN_PRTT_ENRT_RSLT_F

Line 26: from ben_prtt_enrt_rslt_f pen,

22: pea.actn_typ_id,
23: pea.cmpltd_dt,
24: pen.object_version_number rslt_ovn,
25: pea.object_version_number
26: from ben_prtt_enrt_rslt_f pen,
27: ben_prtt_enrt_actn_f pea,
28: ben_pl_bnf_f plb
29: where pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
30: and pea.pl_bnf_id = plb.pl_bnf_id

Line 148: l_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type;

144: l_effective_end_date ben_pl_bnf_ctfn_prvdd_f.effective_end_date%TYPE;
145: l_proc varchar2(72) := g_package||'create_PL_BNF_CTFN_PRVDD';
146: l_object_version_number ben_pl_bnf_ctfn_prvdd_f.object_version_number%TYPE;
147: l_prtt_enrt_actn_id ben_prtt_enrt_actn_f.prtt_enrt_actn_id%type;
148: l_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type;
149: l_actn_typ_cd varchar2(30);
150: --
151: cursor c_pbn is
152: select pbn.prtt_enrt_rslt_id

Line 816: ben_prtt_enrt_rslt_f pen

812: select pea.object_version_number,
813: pea.prtt_enrt_rslt_id,
814: pen.object_version_number
815: from ben_prtt_enrt_actn_f pea,
816: ben_prtt_enrt_rslt_f pen
817: where pea.prtt_enrt_actn_id = l_prtt_enrt_actn_id
818: and pea.business_group_id = p_business_group_id
819: and pen.prtt_enrt_rslt_stat_cd is null
820: and p_effective_date between pea.effective_start_date