APPS.BEN_LF_EVT_CLPS_RESTORE dependencies on BEN_BNFT_PRVDD_LDGR_F

Line 3722: from ben_bnft_prvdd_ldgr_f bckdt_bpl

3718: ,bckdt_bpl.CREATION_DATE
3719: ,bckdt_bpl.OBJECT_VERSION_NUMBER
3720: ,bckdt_bpl.RLD_UP_VAL
3721: ,bckdt_bpl.PER_IN_LER_ID
3722: from ben_bnft_prvdd_ldgr_f bckdt_bpl
3723: where bckdt_bpl.per_in_ler_id = p_bckdt_per_in_ler_id
3724: and bckdt_bpl.business_group_id = p_business_group_id
3725: and bckdt_bpl.prtt_enrt_rslt_id = cp_bckdt_prtt_enrt_rslt_id
3726: union

Line 3783: and bckdt_bpl.BKUP_TBL_TYP_CD = 'BEN_BNFT_PRVDD_LDGR_F'

3779: from ben_le_clsn_n_rstr bckdt_bpl
3780: where bckdt_bpl.per_in_ler_id = p_bckdt_per_in_ler_id
3781: and bckdt_bpl.business_group_id = p_business_group_id
3782: and bckdt_bpl.prtt_enrt_rslt_id = cp_bckdt_prtt_enrt_rslt_id
3783: and bckdt_bpl.BKUP_TBL_TYP_CD = 'BEN_BNFT_PRVDD_LDGR_F'
3784: order by 1;
3785: --
3786: cursor c_curr_bpl(cp_acty_base_rt_id in number,
3787: cp_bnft_prvdr_pool_id in number,

Line 3791: from ben_bnft_prvdd_ldgr_f bpl

3787: cp_bnft_prvdr_pool_id in number,
3788: cp_prtt_enrt_rslt_id in number,
3789: cp_effective_date in date) is
3790: select bpl.*
3791: from ben_bnft_prvdd_ldgr_f bpl
3792: where bpl.per_in_ler_id = p_per_in_ler_id
3793: and bpl.prtt_enrt_rslt_id = cp_prtt_enrt_rslt_id
3794: --
3795: and cp_effective_date between bpl.effective_start_date