APPS.BEN_ORG_DELETE dependencies on BEN_EXT_DATA_ELMT_DECD

Line 282: is select 1 from BEN_EXT_DATA_ELMT_DECD

278: is select 1 from BEN_EXT_CRIT_CMBN
279: where business_group_id = p_bg_id;
280:
281: cursor c70(p_bg_id NUMBER)
282: is select 1 from BEN_EXT_DATA_ELMT_DECD
283: where business_group_id = p_bg_id;
284:
285: cursor c71(p_bg_id NUMBER)
286: is select 1 from BEN_EXT_DATA_ELMT_IN_RCD

Line 2216: -- Testing for values in BEN_EXT_DATA_ELMT_DECD

2212: --
2213: close c69;
2214:
2215: --
2216: -- Testing for values in BEN_EXT_DATA_ELMT_DECD
2217: --
2218: open c70(p_bg_id);
2219: --
2220: fetch c70 into l_temp;

Line 2224: fnd_message.set_token('TABLE_NAME','BEN_EXT_DATA_ELMT_DECD');

2220: fetch c70 into l_temp;
2221: if c70%found then
2222: close c70;
2223: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2224: fnd_message.set_token('TABLE_NAME','BEN_EXT_DATA_ELMT_DECD');
2225: fnd_message.raise_error;
2226: end if;
2227: --
2228: close c70;

Line 5784: delete from BEN_EXT_DATA_ELMT_DECD

5780:
5781: delete from BEN_EXT_CRIT_CMBN
5782: where business_group_id = p_bg_id;
5783:
5784: delete from BEN_EXT_DATA_ELMT_DECD
5785: where business_group_id = p_bg_id;
5786:
5787: delete from BEN_EXT_DATA_ELMT_IN_RCD
5788: where business_group_id = p_bg_id;