APPS.BEN_ORG_DELETE dependencies on BEN_BATCH_COMMU_INFO

Line 990: is select 1 from BEN_BATCH_COMMU_INFO

986: is select 1 from BEN_WV_PRTN_RSN_CTFN_PTIP_F
987: where business_group_id = p_bg_id;
988:
989: cursor c248(p_bg_id NUMBER)
990: is select 1 from BEN_BATCH_COMMU_INFO
991: where business_group_id = p_bg_id;
992:
993: cursor c249(p_bg_id NUMBER)
994: is select 1 from BEN_BATCH_DPNT_INFO

Line 4871: -- Testing for values in BEN_BATCH_COMMU_INFO

4867: --
4868: close c247;
4869:
4870: --
4871: -- Testing for values in BEN_BATCH_COMMU_INFO
4872: --
4873: open c248(p_bg_id);
4874: --
4875: fetch c248 into l_temp;

Line 4879: fnd_message.set_token('TABLE_NAME','BEN_BATCH_COMMU_INFO');

4875: fetch c248 into l_temp;
4876: if c248%found then
4877: close c248;
4878: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4879: fnd_message.set_token('TABLE_NAME','BEN_BATCH_COMMU_INFO');
4880: fnd_message.raise_error;
4881: end if;
4882: --
4883: close c248;

Line 6315: delete from BEN_BATCH_COMMU_INFO

6311:
6312: delete from BEN_WV_PRTN_RSN_CTFN_PTIP_F
6313: where business_group_id = p_bg_id;
6314:
6315: delete from BEN_BATCH_COMMU_INFO
6316: where business_group_id = p_bg_id;
6317:
6318: delete from BEN_BATCH_DPNT_INFO
6319: where business_group_id = p_bg_id;