APPS.BEN_ORG_DELETE dependencies on BEN_EXT_INCL_DATA_ELMT

Line 318: is select 1 from BEN_EXT_INCL_DATA_ELMT

314: is select 1 from BEN_REGN_F
315: where business_group_id = p_bg_id;
316:
317: cursor c79(p_bg_id NUMBER)
318: is select 1 from BEN_EXT_INCL_DATA_ELMT
319: where business_group_id = p_bg_id;
320:
321: cursor c80(p_bg_id NUMBER)
322: is select 1 from BEN_EXT_RCD_IN_FILE

Line 2351: -- Testing for values in BEN_EXT_INCL_DATA_ELMT

2347: --
2348: close c78;
2349:
2350: --
2351: -- Testing for values in BEN_EXT_INCL_DATA_ELMT
2352: --
2353: open c79(p_bg_id);
2354: --
2355: fetch c79 into l_temp;

Line 2359: fnd_message.set_token('TABLE_NAME','BEN_EXT_INCL_DATA_ELMT');

2355: fetch c79 into l_temp;
2356: if c79%found then
2357: close c79;
2358: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2359: fnd_message.set_token('TABLE_NAME','BEN_EXT_INCL_DATA_ELMT');
2360: fnd_message.raise_error;
2361: end if;
2362: --
2363: close c79;

Line 5811: delete from BEN_EXT_INCL_DATA_ELMT

5807:
5808: delete from BEN_REGN_F
5809: where business_group_id = p_bg_id;
5810:
5811: delete from BEN_EXT_INCL_DATA_ELMT
5812: where business_group_id = p_bg_id;
5813:
5814: delete from BEN_EXT_RCD_IN_FILE
5815: where business_group_id = p_bg_id;