APPS.BEN_ORG_DELETE dependencies on BEN_REGN_F

Line 314: is select 1 from BEN_REGN_F

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
315: where business_group_id = p_bg_id;
316:
317: cursor c79(p_bg_id NUMBER)
318: is select 1 from BEN_EXT_INCL_DATA_ELMT

Line 326: is select 1 from BEN_REGN_FOR_REGY_BODY_F

322: is select 1 from BEN_EXT_RCD_IN_FILE
323: where business_group_id = p_bg_id;
324:
325: cursor c81(p_bg_id NUMBER)
326: is select 1 from BEN_REGN_FOR_REGY_BODY_F
327: where business_group_id = p_bg_id;
328:
329: cursor c82(p_bg_id NUMBER)
330: is select 1 from BEN_EXT_INCL_CHG

Line 2336: -- Testing for values in BEN_REGN_F

2332: --
2333: close c77;
2334:
2335: --
2336: -- Testing for values in BEN_REGN_F
2337: --
2338: open c78(p_bg_id);
2339: --
2340: fetch c78 into l_temp;

Line 2344: fnd_message.set_token('TABLE_NAME','BEN_REGN_F');

2340: fetch c78 into l_temp;
2341: if c78%found then
2342: close c78;
2343: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2344: fnd_message.set_token('TABLE_NAME','BEN_REGN_F');
2345: fnd_message.raise_error;
2346: end if;
2347: --
2348: close c78;

Line 2381: -- Testing for values in BEN_REGN_FOR_REGY_BODY_F

2377: --
2378: close c80;
2379:
2380: --
2381: -- Testing for values in BEN_REGN_FOR_REGY_BODY_F
2382: --
2383: open c81(p_bg_id);
2384: --
2385: fetch c81 into l_temp;

Line 2389: fnd_message.set_token('TABLE_NAME','BEN_REGN_FOR_REGY_BODY_F');

2385: fetch c81 into l_temp;
2386: if c81%found then
2387: close c81;
2388: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2389: fnd_message.set_token('TABLE_NAME','BEN_REGN_FOR_REGY_BODY_F');
2390: fnd_message.raise_error;
2391: end if;
2392: --
2393: close c81;

Line 5808: delete from BEN_REGN_F

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;
5810:
5811: delete from BEN_EXT_INCL_DATA_ELMT
5812: where business_group_id = p_bg_id;

Line 5817: delete from BEN_REGN_FOR_REGY_BODY_F

5813:
5814: delete from BEN_EXT_RCD_IN_FILE
5815: where business_group_id = p_bg_id;
5816:
5817: delete from BEN_REGN_FOR_REGY_BODY_F
5818: where business_group_id = p_bg_id;
5819:
5820: delete from BEN_EXT_INCL_CHG
5821: where business_group_id = p_bg_id;

Line 6468: delete from BEN_REGN_F

6464:
6465: delete from BEN_ELIG_ORG_UNIT_PRTE_F
6466: where organization_id = p_org_id;
6467:
6468: delete from BEN_REGN_F
6469: where organization_id = p_org_id;
6470:
6471: delete from BEN_REGN_FOR_REGY_BODY_F
6472: where organization_id = p_org_id;

Line 6471: delete from BEN_REGN_FOR_REGY_BODY_F

6467:
6468: delete from BEN_REGN_F
6469: where organization_id = p_org_id;
6470:
6471: delete from BEN_REGN_FOR_REGY_BODY_F
6472: where organization_id = p_org_id;
6473:
6474: delete from BEN_PER_IN_LGL_ENTY_F
6475: where organization_id = p_org_id;