APPS.BEN_ORG_DELETE dependencies on BEN_DPNT_CVG_ELIGY_PRFL_F

Line 342: is select 1 from BEN_DPNT_CVG_ELIGY_PRFL_F

338: is select 1 from BEN_RPTG_GRP
339: where business_group_id = p_bg_id;
340:
341: cursor c85(p_bg_id NUMBER)
342: is select 1 from BEN_DPNT_CVG_ELIGY_PRFL_F
343: where business_group_id = p_bg_id;
344:
345: cursor c86(p_bg_id NUMBER)
346: is select 1 from BEN_HRS_WKD_IN_PERD_FCTR

Line 2441: -- Testing for values in BEN_DPNT_CVG_ELIGY_PRFL_F

2437: --
2438: close c84;
2439:
2440: --
2441: -- Testing for values in BEN_DPNT_CVG_ELIGY_PRFL_F
2442: --
2443: open c85(p_bg_id);
2444: --
2445: fetch c85 into l_temp;

Line 2449: fnd_message.set_token('TABLE_NAME','BEN_DPNT_CVG_ELIGY_PRFL_F');

2445: fetch c85 into l_temp;
2446: if c85%found then
2447: close c85;
2448: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2449: fnd_message.set_token('TABLE_NAME','BEN_DPNT_CVG_ELIGY_PRFL_F');
2450: fnd_message.raise_error;
2451: end if;
2452: --
2453: close c85;

Line 5829: delete from BEN_DPNT_CVG_ELIGY_PRFL_F

5825:
5826: delete from BEN_RPTG_GRP
5827: where business_group_id = p_bg_id;
5828:
5829: delete from BEN_DPNT_CVG_ELIGY_PRFL_F
5830: where business_group_id = p_bg_id;
5831:
5832: delete from BEN_HRS_WKD_IN_PERD_FCTR
5833: where business_group_id = p_bg_id;