APPS.BEN_ORG_DELETE dependencies on BEN_EXT_WHERE_CLAUSE

Line 334: is select 1 from BEN_EXT_WHERE_CLAUSE

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
335: where business_group_id = p_bg_id;
336:
337: cursor c84(p_bg_id NUMBER)
338: is select 1 from BEN_RPTG_GRP

Line 2411: -- Testing for values in BEN_EXT_WHERE_CLAUSE

2407: --
2408: close c82;
2409:
2410: --
2411: -- Testing for values in BEN_EXT_WHERE_CLAUSE
2412: --
2413: open c83(p_bg_id);
2414: --
2415: fetch c83 into l_temp;

Line 2419: fnd_message.set_token('TABLE_NAME','BEN_EXT_WHERE_CLAUSE');

2415: fetch c83 into l_temp;
2416: if c83%found then
2417: close c83;
2418: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2419: fnd_message.set_token('TABLE_NAME','BEN_EXT_WHERE_CLAUSE');
2420: fnd_message.raise_error;
2421: end if;
2422: --
2423: close c83;

Line 5823: delete from BEN_EXT_WHERE_CLAUSE

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;
5825:
5826: delete from BEN_RPTG_GRP
5827: where business_group_id = p_bg_id;