APPS.BEN_ORG_DELETE dependencies on BEN_BNFT_PRVDR_POOL_F

Line 518: is select 1 from BEN_BNFT_PRVDR_POOL_F

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
519: where business_group_id = p_bg_id;
520:
521: cursor c131(p_bg_id NUMBER)
522: is select 1 from BEN_CMBN_PLIP_F

Line 3101: -- Testing for values in BEN_BNFT_PRVDR_POOL_F

3097: --
3098: close c129;
3099:
3100: --
3101: -- Testing for values in BEN_BNFT_PRVDR_POOL_F
3102: --
3103: open c130(p_bg_id);
3104: --
3105: fetch c130 into l_temp;

Line 3109: fnd_message.set_token('TABLE_NAME','BEN_BNFT_PRVDR_POOL_F');

3105: fetch c130 into l_temp;
3106: if c130%found then
3107: close c130;
3108: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
3109: fnd_message.set_token('TABLE_NAME','BEN_BNFT_PRVDR_POOL_F');
3110: fnd_message.raise_error;
3111: end if;
3112: --
3113: close c130;

Line 5961: delete from BEN_BNFT_PRVDR_POOL_F

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;
5963:
5964: delete from BEN_CMBN_PLIP_F
5965: where business_group_id = p_bg_id;