APPS.BEN_ORG_DELETE dependencies on BEN_DPNT_CVG_RQD_RLSHP_F

Line 350: is select 1 from BEN_DPNT_CVG_RQD_RLSHP_F

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
351: where business_group_id = p_bg_id;
352:
353: cursor c88(p_bg_id NUMBER)
354: is select 1 from BEN_DSGNTR_ENRLD_CVG_F

Line 2471: -- Testing for values in BEN_DPNT_CVG_RQD_RLSHP_F

2467: --
2468: close c86;
2469:
2470: --
2471: -- Testing for values in BEN_DPNT_CVG_RQD_RLSHP_F
2472: --
2473: open c87(p_bg_id);
2474: --
2475: fetch c87 into l_temp;

Line 2479: fnd_message.set_token('TABLE_NAME','BEN_DPNT_CVG_RQD_RLSHP_F');

2475: fetch c87 into l_temp;
2476: if c87%found then
2477: close c87;
2478: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2479: fnd_message.set_token('TABLE_NAME','BEN_DPNT_CVG_RQD_RLSHP_F');
2480: fnd_message.raise_error;
2481: end if;
2482: --
2483: close c87;

Line 5835: delete from BEN_DPNT_CVG_RQD_RLSHP_F

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;
5837:
5838: delete from BEN_DSGNTR_ENRLD_CVG_F
5839: where business_group_id = p_bg_id;