APPS.BEN_LF_EVT_CLPS_RESTORE dependencies on BEN_CBR_QUALD_BNF

Line 2987: l_object_version_number ben_cbr_quald_bnf.object_version_number%type;

2983: --
2984: l_proc varchar2(72) := g_package||'.reinstate_cbr_dates';
2985: --
2986: l_exists varchar2(1);
2987: l_object_version_number ben_cbr_quald_bnf.object_version_number%type;
2988: --
2989: -- Get cobra secondary qualifying event
2990: --
2991: cursor c_get_cbr_per_in_ler is

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

2999: select cqb.*
3000: from ben_le_clsn_n_rstr cqb
3001: where cqb.per_in_ler_id = p_bckdt_per_in_ler_id
3002: and cqb.business_group_id = p_business_group_id
3003: and cqb.bkup_tbl_typ_cd = 'BEN_CBR_QUALD_BNF';
3004: --
3005: cursor c_cqb(p_cbr_quald_bnf_id in number) is
3006: select cqb.*
3007: from ben_cbr_quald_bnf cqb

Line 3007: from ben_cbr_quald_bnf cqb

3003: and cqb.bkup_tbl_typ_cd = 'BEN_CBR_QUALD_BNF';
3004: --
3005: cursor c_cqb(p_cbr_quald_bnf_id in number) is
3006: select cqb.*
3007: from ben_cbr_quald_bnf cqb
3008: where cqb.cbr_quald_bnf_id = p_cbr_quald_bnf_id
3009: and cqb.business_group_id = p_business_group_id;
3010: --
3011: l_bckdt_cqb_rec c_bckdt_cqb%rowtype;

Line 3039: ben_cbr_quald_bnf_api.update_cbr_quald_bnf

3035: close c_cqb;
3036: --
3037: l_object_version_number := l_cqb_rec.object_version_number;
3038: --
3039: ben_cbr_quald_bnf_api.update_cbr_quald_bnf
3040: (p_validate => false
3041: ,p_cbr_quald_bnf_id => l_cqb_rec.cbr_quald_bnf_id
3042: ,p_cbr_elig_perd_end_dt => l_bckdt_cqb_rec.elig_thru_dt
3043: ,p_business_group_id => p_business_group_id

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

3057: --
3058: delete from ben_le_clsn_n_rstr cqb
3059: where cqb.per_in_ler_id = p_bckdt_per_in_ler_id
3060: and cqb.business_group_id = p_business_group_id
3061: and cqb.bkup_tbl_typ_cd = 'BEN_CBR_QUALD_BNF';
3062: --
3063: hr_utility.set_location('Leaving:'|| l_proc, 10);
3064:
3065: end reinstate_cbr_dates;