APPS.BEN_LF_EVT_CLPS_RESTORE dependencies on BEN_BNFT_PRVDD_LDGR_F

Line 3952: from ben_bnft_prvdd_ldgr_f bckdt_bpl

3948: ,bckdt_bpl.CREATION_DATE
3949: ,bckdt_bpl.OBJECT_VERSION_NUMBER
3950: ,bckdt_bpl.RLD_UP_VAL
3951: ,bckdt_bpl.PER_IN_LER_ID
3952: from ben_bnft_prvdd_ldgr_f bckdt_bpl
3953: where bckdt_bpl.per_in_ler_id = p_bckdt_per_in_ler_id
3954: and bckdt_bpl.business_group_id = p_business_group_id
3955: and bckdt_bpl.prtt_enrt_rslt_id = cp_bckdt_prtt_enrt_rslt_id
3956: union

Line 4013: and bckdt_bpl.BKUP_TBL_TYP_CD = 'BEN_BNFT_PRVDD_LDGR_F'

4009: from ben_le_clsn_n_rstr bckdt_bpl
4010: where bckdt_bpl.per_in_ler_id = p_bckdt_per_in_ler_id
4011: and bckdt_bpl.business_group_id = p_business_group_id
4012: and bckdt_bpl.prtt_enrt_rslt_id = cp_bckdt_prtt_enrt_rslt_id
4013: and bckdt_bpl.BKUP_TBL_TYP_CD = 'BEN_BNFT_PRVDD_LDGR_F'
4014: order by 1;
4015: --
4016: cursor c_curr_bpl(cp_acty_base_rt_id in number,
4017: cp_bnft_prvdr_pool_id in number,

Line 4021: from ben_bnft_prvdd_ldgr_f bpl

4017: cp_bnft_prvdr_pool_id in number,
4018: cp_prtt_enrt_rslt_id in number,
4019: cp_effective_date in date) is
4020: select bpl.*
4021: from ben_bnft_prvdd_ldgr_f bpl
4022: where bpl.per_in_ler_id = p_per_in_ler_id
4023: and bpl.prtt_enrt_rslt_id = cp_prtt_enrt_rslt_id
4024: --
4025: and cp_effective_date between bpl.effective_start_date