APPS.BEN_ORG_DELETE dependencies on BEN_BENFTS_GRP

Line 38: is select 1 from BEN_BENFTS_GRP

34: is select 1 from BEN_AGE_FCTR
35: where business_group_id = p_bg_id;
36:
37: cursor c9(p_bg_id NUMBER)
38: is select 1 from BEN_BENFTS_GRP
39: where business_group_id = p_bg_id;
40:
41: cursor c10(p_bg_id NUMBER)
42: is select 1 from BEN_GD_OR_SVC_TYP

Line 806: is select 1 from BEN_BENFTS_GRP_RT_F

802: is select 1 from BEN_ASNT_SET_RT_F
803: where business_group_id = p_bg_id;
804:
805: cursor c202(p_bg_id NUMBER)
806: is select 1 from BEN_BENFTS_GRP_RT_F
807: where business_group_id = p_bg_id;
808:
809: cursor c203(p_bg_id NUMBER)
810: is select 1 from BEN_PRTT_ENRT_RSLT_F

Line 1301: -- Testing for values in BEN_BENFTS_GRP

1297: --
1298: close c8;
1299:
1300: --
1301: -- Testing for values in BEN_BENFTS_GRP
1302: --
1303: open c9(p_bg_id);
1304: --
1305: fetch c9 into l_temp;

Line 1309: fnd_message.set_token('TABLE_NAME','BEN_BENFTS_GRP');

1305: fetch c9 into l_temp;
1306: if c9%found then
1307: close c9;
1308: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
1309: fnd_message.set_token('TABLE_NAME','BEN_BENFTS_GRP');
1310: fnd_message.raise_error;
1311: end if;
1312: --
1313: close c9;

Line 4181: -- Testing for values in BEN_BENFTS_GRP_RT_F

4177: --
4178: close c201;
4179:
4180: --
4181: -- Testing for values in BEN_BENFTS_GRP_RT_F
4182: --
4183: open c202(p_bg_id);
4184: --
4185: fetch c202 into l_temp;

Line 4189: fnd_message.set_token('TABLE_NAME','BEN_BENFTS_GRP_RT_F');

4185: fetch c202 into l_temp;
4186: if c202%found then
4187: close c202;
4188: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4189: fnd_message.set_token('TABLE_NAME','BEN_BENFTS_GRP_RT_F');
4190: fnd_message.raise_error;
4191: end if;
4192: --
4193: close c202;

Line 5601: delete from BEN_BENFTS_GRP

5597:
5598: delete from BEN_AGE_FCTR
5599: where business_group_id = p_bg_id;
5600:
5601: delete from BEN_BENFTS_GRP
5602: where business_group_id = p_bg_id;
5603:
5604: delete from BEN_GD_OR_SVC_TYP
5605: where business_group_id = p_bg_id;

Line 6177: delete from BEN_BENFTS_GRP_RT_F

6173:
6174: delete from BEN_ASNT_SET_RT_F
6175: where business_group_id = p_bg_id;
6176:
6177: delete from BEN_BENFTS_GRP_RT_F
6178: where business_group_id = p_bg_id;
6179:
6180: delete from BEN_PRTT_ENRT_RSLT_F
6181: where business_group_id = p_bg_id;