APPS.BEN_ORG_DELETE dependencies on BEN_PGM_DPNT_CVG_CTFN_F

Line 514: is select 1 from BEN_PGM_DPNT_CVG_CTFN_F

510: is select 1 from BEN_OIPL_F
511: where business_group_id = p_bg_id;
512:
513: cursor c129(p_bg_id NUMBER)
514: is select 1 from BEN_PGM_DPNT_CVG_CTFN_F
515: where business_group_id = p_bg_id;
516:
517: cursor c130(p_bg_id NUMBER)
518: is select 1 from BEN_BNFT_PRVDR_POOL_F

Line 3086: -- Testing for values in BEN_PGM_DPNT_CVG_CTFN_F

3082: --
3083: close c128;
3084:
3085: --
3086: -- Testing for values in BEN_PGM_DPNT_CVG_CTFN_F
3087: --
3088: open c129(p_bg_id);
3089: --
3090: fetch c129 into l_temp;

Line 3094: fnd_message.set_token('TABLE_NAME','BEN_PGM_DPNT_CVG_CTFN_F');

3090: fetch c129 into l_temp;
3091: if c129%found then
3092: close c129;
3093: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3094: fnd_message.set_token('TABLE_NAME','BEN_PGM_DPNT_CVG_CTFN_F');
3095: fnd_message.raise_error;
3096: end if;
3097: --
3098: close c129;

Line 5958: delete from BEN_PGM_DPNT_CVG_CTFN_F

5954:
5955: delete from BEN_OIPL_F
5956: where business_group_id = p_bg_id;
5957:
5958: delete from BEN_PGM_DPNT_CVG_CTFN_F
5959: where business_group_id = p_bg_id;
5960:
5961: delete from BEN_BNFT_PRVDR_POOL_F
5962: where business_group_id = p_bg_id;