APPS.BEN_ORG_DELETE dependencies on BEN_PL_GD_R_SVC_CTFN_F

Line 886: is select 1 from BEN_PL_GD_R_SVC_CTFN_F

882: is select 1 from BEN_ELIG_PER_WV_PL_TYP_F
883: where business_group_id = p_bg_id;
884:
885: cursor c222(p_bg_id NUMBER)
886: is select 1 from BEN_PL_GD_R_SVC_CTFN_F
887: where business_group_id = p_bg_id;
888:
889: cursor c223(p_bg_id NUMBER)
890: is select 1 from BEN_PRMRY_CARE_PRVDR_F

Line 4481: -- Testing for values in BEN_PL_GD_R_SVC_CTFN_F

4477: --
4478: close c221;
4479:
4480: --
4481: -- Testing for values in BEN_PL_GD_R_SVC_CTFN_F
4482: --
4483: open c222(p_bg_id);
4484: --
4485: fetch c222 into l_temp;

Line 4489: fnd_message.set_token('TABLE_NAME','BEN_PL_GD_R_SVC_CTFN_F');

4485: fetch c222 into l_temp;
4486: if c222%found then
4487: close c222;
4488: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4489: fnd_message.set_token('TABLE_NAME','BEN_PL_GD_R_SVC_CTFN_F');
4490: fnd_message.raise_error;
4491: end if;
4492: --
4493: close c222;

Line 6237: delete from BEN_PL_GD_R_SVC_CTFN_F

6233:
6234: delete from BEN_ELIG_PER_WV_PL_TYP_F
6235: where business_group_id = p_bg_id;
6236:
6237: delete from BEN_PL_GD_R_SVC_CTFN_F
6238: where business_group_id = p_bg_id;
6239:
6240: delete from BEN_PRMRY_CARE_PRVDR_F
6241: where business_group_id = p_bg_id;