APPS.BEN_LF_EVT_CLPS_RESTORE dependencies on BEN_CBR_QUALD_BNF

Line 2757: l_object_version_number ben_cbr_quald_bnf.object_version_number%type;

2753: --
2754: l_proc varchar2(72) := g_package||'.reinstate_cbr_dates';
2755: --
2756: l_exists varchar2(1);
2757: l_object_version_number ben_cbr_quald_bnf.object_version_number%type;
2758: --
2759: -- Get cobra secondary qualifying event
2760: --
2761: cursor c_get_cbr_per_in_ler is

Line 2773: and cqb.bkup_tbl_typ_cd = 'BEN_CBR_QUALD_BNF';

2769: select cqb.*
2770: from ben_le_clsn_n_rstr cqb
2771: where cqb.per_in_ler_id = p_bckdt_per_in_ler_id
2772: and cqb.business_group_id = p_business_group_id
2773: and cqb.bkup_tbl_typ_cd = 'BEN_CBR_QUALD_BNF';
2774: --
2775: cursor c_cqb(p_cbr_quald_bnf_id in number) is
2776: select cqb.*
2777: from ben_cbr_quald_bnf cqb

Line 2777: from ben_cbr_quald_bnf cqb

2773: and cqb.bkup_tbl_typ_cd = 'BEN_CBR_QUALD_BNF';
2774: --
2775: cursor c_cqb(p_cbr_quald_bnf_id in number) is
2776: select cqb.*
2777: from ben_cbr_quald_bnf cqb
2778: where cqb.cbr_quald_bnf_id = p_cbr_quald_bnf_id
2779: and cqb.business_group_id = p_business_group_id;
2780: --
2781: l_bckdt_cqb_rec c_bckdt_cqb%rowtype;

Line 2809: ben_cbr_quald_bnf_api.update_cbr_quald_bnf

2805: close c_cqb;
2806: --
2807: l_object_version_number := l_cqb_rec.object_version_number;
2808: --
2809: ben_cbr_quald_bnf_api.update_cbr_quald_bnf
2810: (p_validate => false
2811: ,p_cbr_quald_bnf_id => l_cqb_rec.cbr_quald_bnf_id
2812: ,p_cbr_elig_perd_end_dt => l_bckdt_cqb_rec.elig_thru_dt
2813: ,p_business_group_id => p_business_group_id

Line 2831: and cqb.bkup_tbl_typ_cd = 'BEN_CBR_QUALD_BNF';

2827: --
2828: delete from ben_le_clsn_n_rstr cqb
2829: where cqb.per_in_ler_id = p_bckdt_per_in_ler_id
2830: and cqb.business_group_id = p_business_group_id
2831: and cqb.bkup_tbl_typ_cd = 'BEN_CBR_QUALD_BNF';
2832: --
2833: hr_utility.set_location('Leaving:'|| l_proc, 10);
2834:
2835: end reinstate_cbr_dates;