DBA Data[Home] [Help]

APPS.BEN_PL_BNF_CTFN_PRVDD_API dependencies on BEN_PL_BNF_F

Line 28: ben_pl_bnf_f plb

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
31: and plb.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
32: and pea.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id

Line 153: from ben_pl_bnf_f pbn

149: l_actn_typ_cd varchar2(30);
150: --
151: cursor c_pbn is
152: select pbn.prtt_enrt_rslt_id
153: from ben_pl_bnf_f pbn
154: where pbn.pl_bnf_id = p_pl_bnf_id
155: and pbn.business_group_id = p_business_group_id
156: and p_effective_date between
157: pbn.effective_start_date and pbn.effective_end_date;