DBA Data[Home] [Help]

APPS.BEN_CLOSE_ENROLLMENT dependencies on BEN_CBR_QUALD_BNF

Line 2471: from ben_cbr_quald_bnf cqb

2467: and crp.init_evt_flag = 'N';
2468: --
2469: cursor c_get_cbr_quald_bnf(p_cbr_per_in_ler_id number) is
2470: select cqb.*
2471: from ben_cbr_quald_bnf cqb
2472: ,ben_cbr_per_in_ler crp
2473: where crp.cbr_per_in_ler_id = p_cbr_per_in_ler_id
2474: and crp.cbr_quald_bnf_id = cqb.cbr_quald_bnf_id
2475: and cqb.business_group_id = p_business_group_id

Line 2596: ben_cbr_quald_bnf_api.update_cbr_quald_bnf

2592: for l_cqb_rec in c_get_cbr_quald_bnf(l_crp_rec.cbr_per_in_ler_id) loop
2593: --
2594: l_object_version_number := l_cqb_rec.object_version_number;
2595: --
2596: ben_cbr_quald_bnf_api.update_cbr_quald_bnf
2597: (p_validate => false
2598: ,p_cbr_quald_bnf_id => l_cqb_rec.cbr_quald_bnf_id
2599: ,p_cbr_elig_perd_end_dt => l_crp_rec.prvs_elig_perd_end_dt
2600: ,p_cbr_inelg_rsn_cd => null