APPS.BEN_ORG_DELETE dependencies on BEN_ELIG_PER_OPT_F

Line 878: is select 1 from BEN_ELIG_PER_OPT_F

874: is select 1 from BEN_ACTL_PREM_VRBL_RT_F
875: where business_group_id = p_bg_id;
876:
877: cursor c220(p_bg_id NUMBER)
878: is select 1 from BEN_ELIG_PER_OPT_F
879: where business_group_id = p_bg_id;
880:
881: cursor c221(p_bg_id NUMBER)
882: is select 1 from BEN_ELIG_PER_WV_PL_TYP_F

Line 4451: -- Testing for values in BEN_ELIG_PER_OPT_F

4447: --
4448: close c219;
4449:
4450: --
4451: -- Testing for values in BEN_ELIG_PER_OPT_F
4452: --
4453: open c220(p_bg_id);
4454: --
4455: fetch c220 into l_temp;

Line 4459: fnd_message.set_token('TABLE_NAME','BEN_ELIG_PER_OPT_F');

4455: fetch c220 into l_temp;
4456: if c220%found then
4457: close c220;
4458: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4459: fnd_message.set_token('TABLE_NAME','BEN_ELIG_PER_OPT_F');
4460: fnd_message.raise_error;
4461: end if;
4462: --
4463: close c220;

Line 6231: delete from BEN_ELIG_PER_OPT_F

6227:
6228: delete from BEN_ACTL_PREM_VRBL_RT_F
6229: where business_group_id = p_bg_id;
6230:
6231: delete from BEN_ELIG_PER_OPT_F
6232: where business_group_id = p_bg_id;
6233:
6234: delete from BEN_ELIG_PER_WV_PL_TYP_F
6235: where business_group_id = p_bg_id;