APPS.BEN_ORG_DELETE dependencies on BEN_SVC_AREA_F

Line 266: is select 1 from BEN_SVC_AREA_F

262: is select 1 from BEN_EXT_RSLT
263: where business_group_id = p_bg_id;
264:
265: cursor c66(p_bg_id NUMBER)
266: is select 1 from BEN_SVC_AREA_F
267: where business_group_id = p_bg_id;
268:
269: cursor c67(p_bg_id NUMBER)
270: is select 1 from BEN_VSTG_LOS_RQMT

Line 2156: -- Testing for values in BEN_SVC_AREA_F

2152: --
2153: close c65;
2154:
2155: --
2156: -- Testing for values in BEN_SVC_AREA_F
2157: --
2158: open c66(p_bg_id);
2159: --
2160: fetch c66 into l_temp;

Line 2164: fnd_message.set_token('TABLE_NAME','BEN_SVC_AREA_F');

2160: fetch c66 into l_temp;
2161: if c66%found then
2162: close c66;
2163: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2164: fnd_message.set_token('TABLE_NAME','BEN_SVC_AREA_F');
2165: fnd_message.raise_error;
2166: end if;
2167: --
2168: close c66;

Line 5772: delete from BEN_SVC_AREA_F

5768:
5769: delete from BEN_EXT_RSLT
5770: where business_group_id = p_bg_id;
5771:
5772: delete from BEN_SVC_AREA_F
5773: where business_group_id = p_bg_id;
5774:
5775: delete from BEN_VSTG_LOS_RQMT
5776: where business_group_id = p_bg_id;