APPS.BEN_ORG_DELETE dependencies on BEN_RPTG_GRP

Line 338: is select 1 from BEN_RPTG_GRP

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
339: where business_group_id = p_bg_id;
340:
341: cursor c85(p_bg_id NUMBER)
342: is select 1 from BEN_DPNT_CVG_ELIGY_PRFL_F

Line 2426: -- Testing for values in BEN_RPTG_GRP

2422: --
2423: close c83;
2424:
2425: --
2426: -- Testing for values in BEN_RPTG_GRP
2427: --
2428: open c84(p_bg_id);
2429: --
2430: fetch c84 into l_temp;

Line 2434: fnd_message.set_token('TABLE_NAME','BEN_RPTG_GRP');

2430: fetch c84 into l_temp;
2431: if c84%found then
2432: close c84;
2433: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2434: fnd_message.set_token('TABLE_NAME','BEN_RPTG_GRP');
2435: fnd_message.raise_error;
2436: end if;
2437: --
2438: close c84;

Line 5826: delete from BEN_RPTG_GRP

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;
5828:
5829: delete from BEN_DPNT_CVG_ELIGY_PRFL_F
5830: where business_group_id = p_bg_id;