APPS.BEN_ORG_DELETE dependencies on BEN_EXT_DATA_ELMT_IN_RCD

Line 286: is select 1 from BEN_EXT_DATA_ELMT_IN_RCD

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
287: where business_group_id = p_bg_id;
288:
289: cursor c72(p_bg_id NUMBER)
290: is select 1 from BEN_EXT_RSLT_DTL

Line 2231: -- Testing for values in BEN_EXT_DATA_ELMT_IN_RCD

2227: --
2228: close c70;
2229:
2230: --
2231: -- Testing for values in BEN_EXT_DATA_ELMT_IN_RCD
2232: --
2233: open c71(p_bg_id);
2234: --
2235: fetch c71 into l_temp;

Line 2239: fnd_message.set_token('TABLE_NAME','BEN_EXT_DATA_ELMT_IN_RCD');

2235: fetch c71 into l_temp;
2236: if c71%found then
2237: close c71;
2238: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2239: fnd_message.set_token('TABLE_NAME','BEN_EXT_DATA_ELMT_IN_RCD');
2240: fnd_message.raise_error;
2241: end if;
2242: --
2243: close c71;

Line 5787: delete from BEN_EXT_DATA_ELMT_IN_RCD

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;
5789:
5790: delete from BEN_EXT_RSLT_DTL
5791: where business_group_id = p_bg_id;