DBA Data[Home] [Help]

APPS.BEN_LF_EVT_CLPS_RESTORE dependencies on BEN_PL_BNF_CTFN_PRVDD_F

Line 5006: ben_pl_bnf_ctfn_prvdd_f pbc

5002: select pbc.BNF_CTFN_RECD_DT,
5003: pea.ACTN_TYP_ID,
5004: pbc.BNF_CTFN_TYP_CD
5005: from ben_prtt_enrt_actn_f pea,
5006: ben_pl_bnf_ctfn_prvdd_f pbc
5007: where pea.per_in_ler_id = p_bckdt_per_in_ler_id
5008: and pea.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
5009: and pea.business_group_id = p_business_group_id
5010: and pea.PL_BNF_ID = p_old_PL_BNF_ID

Line 5024: ben_pl_bnf_ctfn_prvdd_f pbc

5020: cursor c_pbc(cp_actn_typ_id in number,
5021: cp_BNF_CTFN_TYP_CD in varchar2) is
5022: select pbc.*
5023: from ben_prtt_enrt_actn_f pea,
5024: ben_pl_bnf_ctfn_prvdd_f pbc
5025: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5026: and pea.actn_typ_id = cp_actn_typ_id
5027: and pea.business_group_id = p_business_group_id
5028: and pea.per_in_ler_id = p_per_in_ler_id