APPS.BEN_ORG_DELETE dependencies on BEN_BNFT_VRBL_RT_RL_F

Line 858: is select 1 from BEN_BNFT_VRBL_RT_RL_F

854: is select 1 from BEN_ACTL_PREM_VRBL_RT_RL_F
855: where business_group_id = p_bg_id;
856:
857: cursor c215(p_bg_id NUMBER)
858: is select 1 from BEN_BNFT_VRBL_RT_RL_F
859: where business_group_id = p_bg_id;
860:
861: cursor c216(p_bg_id NUMBER)
862: is select 1 from BEN_ELIG_PPL_GRP_PRTE_F

Line 4376: -- Testing for values in BEN_BNFT_VRBL_RT_RL_F

4372: --
4373: close c214;
4374:
4375: --
4376: -- Testing for values in BEN_BNFT_VRBL_RT_RL_F
4377: --
4378: open c215(p_bg_id);
4379: --
4380: fetch c215 into l_temp;

Line 4384: fnd_message.set_token('TABLE_NAME','BEN_BNFT_VRBL_RT_RL_F');

4380: fetch c215 into l_temp;
4381: if c215%found then
4382: close c215;
4383: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4384: fnd_message.set_token('TABLE_NAME','BEN_BNFT_VRBL_RT_RL_F');
4385: fnd_message.raise_error;
4386: end if;
4387: --
4388: close c215;

Line 6216: delete from BEN_BNFT_VRBL_RT_RL_F

6212:
6213: delete from BEN_ACTL_PREM_VRBL_RT_RL_F
6214: where business_group_id = p_bg_id;
6215:
6216: delete from BEN_BNFT_VRBL_RT_RL_F
6217: where business_group_id = p_bg_id;
6218:
6219: delete from BEN_ELIG_PPL_GRP_PRTE_F
6220: where business_group_id = p_bg_id;