APPS.BEN_ORG_DELETE dependencies on BEN_EXT_RSLT

Line 262: is select 1 from BEN_EXT_RSLT

258: is select 1 from BEN_EXT_DATA_ELMT
259: where business_group_id = p_bg_id;
260:
261: cursor c65(p_bg_id NUMBER)
262: is select 1 from BEN_EXT_RSLT
263: where business_group_id = p_bg_id;
264:
265: cursor c66(p_bg_id NUMBER)
266: is select 1 from BEN_SVC_AREA_F

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 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 2141: -- Testing for values in BEN_EXT_RSLT

2137: --
2138: close c64;
2139:
2140: --
2141: -- Testing for values in BEN_EXT_RSLT
2142: --
2143: open c65(p_bg_id);
2144: --
2145: fetch c65 into l_temp;

Line 2149: fnd_message.set_token('TABLE_NAME','BEN_EXT_RSLT');

2145: fetch c65 into l_temp;
2146: if c65%found then
2147: close c65;
2148: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2149: fnd_message.set_token('TABLE_NAME','BEN_EXT_RSLT');
2150: fnd_message.raise_error;
2151: end if;
2152: --
2153: close c65;

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 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 5769: delete from BEN_EXT_RSLT

5765:
5766: delete from BEN_EXT_DATA_ELMT
5767: where business_group_id = p_bg_id;
5768:
5769: delete from BEN_EXT_RSLT
5770: where business_group_id = p_bg_id;
5771:
5772: delete from BEN_SVC_AREA_F
5773: where business_group_id = p_bg_id;

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;

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;