APPS.BEN_ORG_DELETE dependencies on BEN_COMP_LVL_FCTR

Line 298: is select 1 from BEN_COMP_LVL_FCTR

294: is select 1 from BEN_SVC_AREA_PSTL_ZIP_RNG_F
295: where business_group_id = p_bg_id;
296:
297: cursor c74(p_bg_id NUMBER)
298: is select 1 from BEN_COMP_LVL_FCTR
299: where business_group_id = p_bg_id;
300:
301: cursor c75(p_bg_id NUMBER)
302: is select 1 from BEN_ELIG_LGL_ENTY_PRTE_F

Line 2276: -- Testing for values in BEN_COMP_LVL_FCTR

2272: --
2273: close c73;
2274:
2275: --
2276: -- Testing for values in BEN_COMP_LVL_FCTR
2277: --
2278: open c74(p_bg_id);
2279: --
2280: fetch c74 into l_temp;

Line 2284: fnd_message.set_token('TABLE_NAME','BEN_COMP_LVL_FCTR');

2280: fetch c74 into l_temp;
2281: if c74%found then
2282: close c74;
2283: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2284: fnd_message.set_token('TABLE_NAME','BEN_COMP_LVL_FCTR');
2285: fnd_message.raise_error;
2286: end if;
2287: --
2288: close c74;

Line 5796: delete from BEN_COMP_LVL_FCTR

5792:
5793: delete from BEN_SVC_AREA_PSTL_ZIP_RNG_F
5794: where business_group_id = p_bg_id;
5795:
5796: delete from BEN_COMP_LVL_FCTR
5797: where business_group_id = p_bg_id;
5798:
5799: delete from BEN_ELIG_LGL_ENTY_PRTE_F
5800: where business_group_id = p_bg_id;