APPS.BEN_ORG_DELETE dependencies on BEN_REGN_FOR_REGY_BODY_F

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