APPS.BEN_ORG_DELETE dependencies on BEN_BATCH_DPNT_INFO

Line 994: is select 1 from BEN_BATCH_DPNT_INFO

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
995: where business_group_id = p_bg_id;
996:
997: cursor c250(p_bg_id NUMBER)
998: is select 1 from BEN_BATCH_ELCTBL_CHC_INFO

Line 4886: -- Testing for values in BEN_BATCH_DPNT_INFO

4882: --
4883: close c248;
4884:
4885: --
4886: -- Testing for values in BEN_BATCH_DPNT_INFO
4887: --
4888: open c249(p_bg_id);
4889: --
4890: fetch c249 into l_temp;

Line 4894: fnd_message.set_token('TABLE_NAME','BEN_BATCH_DPNT_INFO');

4890: fetch c249 into l_temp;
4891: if c249%found then
4892: close c249;
4893: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4894: fnd_message.set_token('TABLE_NAME','BEN_BATCH_DPNT_INFO');
4895: fnd_message.raise_error;
4896: end if;
4897: --
4898: close c249;

Line 6318: delete from BEN_BATCH_DPNT_INFO

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;
6320:
6321: delete from BEN_BATCH_ELCTBL_CHC_INFO
6322: where business_group_id = p_bg_id;