DBA Data[Home] [Help]

APPS.BEN_LF_EVT_CLPS_RESTORE dependencies on BEN_CVRD_DPNT_CTFN_PRVDD_F

Line 4457: ben_cvrd_dpnt_ctfn_prvdd_f cpp

4453: select cpp.DPNT_DSGN_CTFN_RECD_DT,
4454: pea.ACTN_TYP_ID,
4455: cpp.DPNT_DSGN_CTFN_TYP_CD
4456: from ben_prtt_enrt_actn_f pea,
4457: ben_cvrd_dpnt_ctfn_prvdd_f cpp
4458: where pea.per_in_ler_id = p_bckdt_per_in_ler_id
4459: and pea.prtt_enrt_rslt_id = p_bckdt_prtt_enrt_rslt_id
4460: and pea.business_group_id = p_business_group_id
4461: and pea.elig_cvrd_dpnt_id = p_old_elig_cvrd_dpnt_id

Line 4478: ben_cvrd_dpnt_ctfn_prvdd_f cpp

4474: cursor c_cpp(cp_actn_typ_id in number,
4475: cp_DPNT_DSGN_CTFN_TYP_CD in varchar2) is
4476: select cpp.*
4477: from ben_prtt_enrt_actn_f pea,
4478: ben_cvrd_dpnt_ctfn_prvdd_f cpp
4479: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
4480: and pea.actn_typ_id = cp_actn_typ_id
4481: and pea.business_group_id = p_business_group_id
4482: and pea.per_in_ler_id = p_per_in_ler_id