APPS.BEN_ORG_DELETE dependencies on BEN_HRS_WKD_IN_PERD_FCTR

Line 346: is select 1 from BEN_HRS_WKD_IN_PERD_FCTR

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
347: where business_group_id = p_bg_id;
348:
349: cursor c87(p_bg_id NUMBER)
350: is select 1 from BEN_DPNT_CVG_RQD_RLSHP_F

Line 2456: -- Testing for values in BEN_HRS_WKD_IN_PERD_FCTR

2452: --
2453: close c85;
2454:
2455: --
2456: -- Testing for values in BEN_HRS_WKD_IN_PERD_FCTR
2457: --
2458: open c86(p_bg_id);
2459: --
2460: fetch c86 into l_temp;

Line 2464: fnd_message.set_token('TABLE_NAME','BEN_HRS_WKD_IN_PERD_FCTR');

2460: fetch c86 into l_temp;
2461: if c86%found then
2462: close c86;
2463: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2464: fnd_message.set_token('TABLE_NAME','BEN_HRS_WKD_IN_PERD_FCTR');
2465: fnd_message.raise_error;
2466: end if;
2467: --
2468: close c86;

Line 5832: delete from BEN_HRS_WKD_IN_PERD_FCTR

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;
5834:
5835: delete from BEN_DPNT_CVG_RQD_RLSHP_F
5836: where business_group_id = p_bg_id;