DBA Data[Home] [Help]

APPS.BEN_CLOSE_ENROLLMENT dependencies on BEN_CBR_QUALD_BNF

Line 2511: from ben_cbr_quald_bnf cqb

2507: and crp.init_evt_flag = 'N';
2508: --
2509: cursor c_get_cbr_quald_bnf(p_cbr_per_in_ler_id number) is
2510: select cqb.*
2511: from ben_cbr_quald_bnf cqb
2512: ,ben_cbr_per_in_ler crp
2513: where crp.cbr_per_in_ler_id = p_cbr_per_in_ler_id
2514: and crp.cbr_quald_bnf_id = cqb.cbr_quald_bnf_id
2515: and cqb.business_group_id = p_business_group_id

Line 2645: ben_cbr_quald_bnf_api.update_cbr_quald_bnf

2641: for l_cqb_rec in c_get_cbr_quald_bnf(l_crp_rec.cbr_per_in_ler_id) loop
2642: --
2643: l_object_version_number := l_cqb_rec.object_version_number;
2644: --
2645: ben_cbr_quald_bnf_api.update_cbr_quald_bnf
2646: (p_validate => false
2647: ,p_cbr_quald_bnf_id => l_cqb_rec.cbr_quald_bnf_id
2648: ,p_cbr_elig_perd_end_dt => l_crp_rec.prvs_elig_perd_end_dt
2649: ,p_cbr_inelg_rsn_cd => null