APPS.BEN_CLOSE_ENROLLMENT dependencies on BEN_CBR_PER_IN_LER

Line 2504: from ben_cbr_per_in_ler crp

2500: and pel.business_group_id = p_business_group_id;
2501: --
2502: cursor c_get_cbr_per_in_ler is
2503: select crp.*
2504: from ben_cbr_per_in_ler crp
2505: where crp.per_in_ler_id = p_per_in_ler_id
2506: and crp.business_group_id = p_business_group_id
2507: and crp.init_evt_flag = 'N';
2508: --

Line 2512: ,ben_cbr_per_in_ler crp

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

Line 2657: ben_cbr_per_in_ler_api.delete_cbr_per_in_ler

2653: );
2654: --
2655: -- Delete the cobra per_in_ler row.
2656: --
2657: ben_cbr_per_in_ler_api.delete_cbr_per_in_ler
2658: (p_validate => false
2659: ,p_cbr_per_in_ler_id => l_crp_rec.cbr_per_in_ler_id
2660: ,p_object_version_number => l_crp_rec.object_version_number
2661: ,p_effective_date => p_effective_date