APPS.BEN_ORG_DELETE dependencies on BEN_EXT_INCL_CHG

Line 330: is select 1 from BEN_EXT_INCL_CHG

326: is select 1 from BEN_REGN_FOR_REGY_BODY_F
327: where business_group_id = p_bg_id;
328:
329: cursor c82(p_bg_id NUMBER)
330: is select 1 from BEN_EXT_INCL_CHG
331: where business_group_id = p_bg_id;
332:
333: cursor c83(p_bg_id NUMBER)
334: is select 1 from BEN_EXT_WHERE_CLAUSE

Line 2396: -- Testing for values in BEN_EXT_INCL_CHG

2392: --
2393: close c81;
2394:
2395: --
2396: -- Testing for values in BEN_EXT_INCL_CHG
2397: --
2398: open c82(p_bg_id);
2399: --
2400: fetch c82 into l_temp;

Line 2404: fnd_message.set_token('TABLE_NAME','BEN_EXT_INCL_CHG');

2400: fetch c82 into l_temp;
2401: if c82%found then
2402: close c82;
2403: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2404: fnd_message.set_token('TABLE_NAME','BEN_EXT_INCL_CHG');
2405: fnd_message.raise_error;
2406: end if;
2407: --
2408: close c82;

Line 5820: delete from BEN_EXT_INCL_CHG

5816:
5817: delete from BEN_REGN_FOR_REGY_BODY_F
5818: where business_group_id = p_bg_id;
5819:
5820: delete from BEN_EXT_INCL_CHG
5821: where business_group_id = p_bg_id;
5822:
5823: delete from BEN_EXT_WHERE_CLAUSE
5824: where business_group_id = p_bg_id;