APPS.BEN_ORG_DELETE dependencies on BEN_EXT_RSLT_DTL

Line 290: is select 1 from BEN_EXT_RSLT_DTL

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
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

Line 2246: -- Testing for values in BEN_EXT_RSLT_DTL

2242: --
2243: close c71;
2244:
2245: --
2246: -- Testing for values in BEN_EXT_RSLT_DTL
2247: --
2248: open c72(p_bg_id);
2249: --
2250: fetch c72 into l_temp;

Line 2254: fnd_message.set_token('TABLE_NAME','BEN_EXT_RSLT_DTL');

2250: fetch c72 into l_temp;
2251: if c72%found then
2252: close c72;
2253: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2254: fnd_message.set_token('TABLE_NAME','BEN_EXT_RSLT_DTL');
2255: fnd_message.raise_error;
2256: end if;
2257: --
2258: close c72;

Line 5790: delete from BEN_EXT_RSLT_DTL

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;
5792:
5793: delete from BEN_SVC_AREA_PSTL_ZIP_RNG_F
5794: where business_group_id = p_bg_id;