APPS.BEN_ORG_DELETE dependencies on BEN_SVC_AREA_PSTL_ZIP_RNG_F

Line 294: is select 1 from BEN_SVC_AREA_PSTL_ZIP_RNG_F

290: is select 1 from BEN_EXT_RSLT_DTL
291: where business_group_id = p_bg_id;
292:
293: cursor c73(p_bg_id NUMBER)
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

Line 2261: -- Testing for values in BEN_SVC_AREA_PSTL_ZIP_RNG_F

2257: --
2258: close c72;
2259:
2260: --
2261: -- Testing for values in BEN_SVC_AREA_PSTL_ZIP_RNG_F
2262: --
2263: open c73(p_bg_id);
2264: --
2265: fetch c73 into l_temp;

Line 2269: fnd_message.set_token('TABLE_NAME','BEN_SVC_AREA_PSTL_ZIP_RNG_F');

2265: fetch c73 into l_temp;
2266: if c73%found then
2267: close c73;
2268: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2269: fnd_message.set_token('TABLE_NAME','BEN_SVC_AREA_PSTL_ZIP_RNG_F');
2270: fnd_message.raise_error;
2271: end if;
2272: --
2273: close c73;

Line 5793: delete from BEN_SVC_AREA_PSTL_ZIP_RNG_F

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