DBA Data[Home] [Help]

APPS.BEN_LF_EVT_CLPS_RESTORE dependencies on BEN_PL_BNF_CTFN_PRVDD_F

Line 5257: ben_pl_bnf_ctfn_prvdd_f pbc

5253: select pbc.BNF_CTFN_RECD_DT,
5254: pea.ACTN_TYP_ID,
5255: pbc.BNF_CTFN_TYP_CD
5256: from ben_prtt_enrt_actn_f pea,
5257: ben_pl_bnf_ctfn_prvdd_f pbc
5258: where pea.per_in_ler_id = p_bckdt_per_in_ler_id
5259: and pea.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
5260: and pea.business_group_id = p_business_group_id
5261: and pea.PL_BNF_ID = p_old_PL_BNF_ID

Line 5275: ben_pl_bnf_ctfn_prvdd_f pbc

5271: cursor c_pbc(cp_actn_typ_id in number,
5272: cp_BNF_CTFN_TYP_CD in varchar2) is
5273: select pbc.*
5274: from ben_prtt_enrt_actn_f pea,
5275: ben_pl_bnf_ctfn_prvdd_f pbc
5276: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5277: and pea.actn_typ_id = cp_actn_typ_id
5278: and pea.business_group_id = p_business_group_id
5279: and pea.per_in_ler_id = p_per_in_ler_id