APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_PPL_GRP_PRTE_F

Line 862: is select 1 from BEN_ELIG_PPL_GRP_PRTE_F

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
863: where business_group_id = p_bg_id;
864:
865: cursor c217(p_bg_id NUMBER)
866: is select 1 from BEN_PRTN_ELIG_PRFL_F

Line 4391: -- Testing for values in BEN_ELIG_PPL_GRP_PRTE_F

4387: --
4388: close c215;
4389:
4390: --
4391: -- Testing for values in BEN_ELIG_PPL_GRP_PRTE_F
4392: --
4393: open c216(p_bg_id);
4394: --
4395: fetch c216 into l_temp;

Line 4399: fnd_message.set_token('TABLE_NAME','BEN_ELIG_PPL_GRP_PRTE_F');

4395: fetch c216 into l_temp;
4396: if c216%found then
4397: close c216;
4398: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4399: fnd_message.set_token('TABLE_NAME','BEN_ELIG_PPL_GRP_PRTE_F');
4400: fnd_message.raise_error;
4401: end if;
4402: --
4403: close c216;

Line 6219: delete from BEN_ELIG_PPL_GRP_PRTE_F

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;
6221:
6222: delete from BEN_PRTN_ELIG_PRFL_F
6223: where business_group_id = p_bg_id;