APPS.BEN_ORG_DELETE dependencies on BEN_PRMRY_CARE_PRVDR_F

Line 890: is select 1 from BEN_PRMRY_CARE_PRVDR_F

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
891: where business_group_id = p_bg_id;
892:
893: cursor c224(p_bg_id NUMBER)
894: is select 1 from BEN_PRTT_ENRT_ACTN_F

Line 4496: -- Testing for values in BEN_PRMRY_CARE_PRVDR_F

4492: --
4493: close c222;
4494:
4495: --
4496: -- Testing for values in BEN_PRMRY_CARE_PRVDR_F
4497: --
4498: open c223(p_bg_id);
4499: --
4500: fetch c223 into l_temp;

Line 4504: fnd_message.set_token('TABLE_NAME','BEN_PRMRY_CARE_PRVDR_F');

4500: fetch c223 into l_temp;
4501: if c223%found then
4502: close c223;
4503: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4504: fnd_message.set_token('TABLE_NAME','BEN_PRMRY_CARE_PRVDR_F');
4505: fnd_message.raise_error;
4506: end if;
4507: --
4508: close c223;

Line 6240: delete from BEN_PRMRY_CARE_PRVDR_F

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;
6242:
6243: delete from BEN_PRTT_ENRT_ACTN_F
6244: where business_group_id = p_bg_id;