APPS.BEN_ORG_DELETE dependencies on BEN_EXT_RSLT_ERR

Line 310: is select 1 from BEN_EXT_RSLT_ERR

306: is select 1 from BEN_ELIG_ORG_UNIT_PRTE_F
307: where business_group_id = p_bg_id;
308:
309: cursor c77(p_bg_id NUMBER)
310: is select 1 from BEN_EXT_RSLT_ERR
311: where business_group_id = p_bg_id;
312:
313: cursor c78(p_bg_id NUMBER)
314: is select 1 from BEN_REGN_F

Line 2321: -- Testing for values in BEN_EXT_RSLT_ERR

2317: --
2318: close c76;
2319:
2320: --
2321: -- Testing for values in BEN_EXT_RSLT_ERR
2322: --
2323: open c77(p_bg_id);
2324: --
2325: fetch c77 into l_temp;

Line 2329: fnd_message.set_token('TABLE_NAME','BEN_EXT_RSLT_ERR');

2325: fetch c77 into l_temp;
2326: if c77%found then
2327: close c77;
2328: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2329: fnd_message.set_token('TABLE_NAME','BEN_EXT_RSLT_ERR');
2330: fnd_message.raise_error;
2331: end if;
2332: --
2333: close c77;

Line 5805: delete from BEN_EXT_RSLT_ERR

5801:
5802: delete from BEN_ELIG_ORG_UNIT_PRTE_F
5803: where business_group_id = p_bg_id;
5804:
5805: delete from BEN_EXT_RSLT_ERR
5806: where business_group_id = p_bg_id;
5807:
5808: delete from BEN_REGN_F
5809: where business_group_id = p_bg_id;