APPS.BEN_CLOSE_ENROLLMENT dependencies on BEN_CBR_PER_IN_LER

Line 2464: from ben_cbr_per_in_ler crp

2460: and pel.business_group_id = p_business_group_id;
2461: --
2462: cursor c_get_cbr_per_in_ler is
2463: select crp.*
2464: from ben_cbr_per_in_ler crp
2465: where crp.per_in_ler_id = p_per_in_ler_id
2466: and crp.business_group_id = p_business_group_id
2467: and crp.init_evt_flag = 'N';
2468: --

Line 2472: ,ben_cbr_per_in_ler crp

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
2476: and cqb.business_group_id = crp.business_group_id;

Line 2608: ben_cbr_per_in_ler_api.delete_cbr_per_in_ler

2604: );
2605: --
2606: -- Delete the cobra per_in_ler row.
2607: --
2608: ben_cbr_per_in_ler_api.delete_cbr_per_in_ler
2609: (p_validate => false
2610: ,p_cbr_per_in_ler_id => l_crp_rec.cbr_per_in_ler_id
2611: ,p_object_version_number => l_crp_rec.object_version_number
2612: ,p_effective_date => p_effective_date