APPS.BEN_ORG_DELETE dependencies on BEN_DSGNTR_ENRLD_CVG_F

Line 354: is select 1 from BEN_DSGNTR_ENRLD_CVG_F

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
355: where business_group_id = p_bg_id;
356:
357: cursor c89(p_bg_id NUMBER)
358: is select 1 from BEN_ELIG_COMP_LVL_PRTE_F

Line 2486: -- Testing for values in BEN_DSGNTR_ENRLD_CVG_F

2482: --
2483: close c87;
2484:
2485: --
2486: -- Testing for values in BEN_DSGNTR_ENRLD_CVG_F
2487: --
2488: open c88(p_bg_id);
2489: --
2490: fetch c88 into l_temp;

Line 2494: fnd_message.set_token('TABLE_NAME','BEN_DSGNTR_ENRLD_CVG_F');

2490: fetch c88 into l_temp;
2491: if c88%found then
2492: close c88;
2493: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
2494: fnd_message.set_token('TABLE_NAME','BEN_DSGNTR_ENRLD_CVG_F');
2495: fnd_message.raise_error;
2496: end if;
2497: --
2498: close c88;

Line 5838: delete from BEN_DSGNTR_ENRLD_CVG_F

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;
5840:
5841: delete from BEN_ELIG_COMP_LVL_PRTE_F
5842: where business_group_id = p_bg_id;