APPS.BEN_ORG_DELETE dependencies on BEN_PRTT_ENRT_ACTN_F

Line 894: is select 1 from BEN_PRTT_ENRT_ACTN_F

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
895: where business_group_id = p_bg_id;
896:
897: cursor c225(p_bg_id NUMBER)
898: is select 1 from BEN_PRTT_ENRT_CTFN_PRVDD_F

Line 4511: -- Testing for values in BEN_PRTT_ENRT_ACTN_F

4507: --
4508: close c223;
4509:
4510: --
4511: -- Testing for values in BEN_PRTT_ENRT_ACTN_F
4512: --
4513: open c224(p_bg_id);
4514: --
4515: fetch c224 into l_temp;

Line 4519: fnd_message.set_token('TABLE_NAME','BEN_PRTT_ENRT_ACTN_F');

4515: fetch c224 into l_temp;
4516: if c224%found then
4517: close c224;
4518: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4519: fnd_message.set_token('TABLE_NAME','BEN_PRTT_ENRT_ACTN_F');
4520: fnd_message.raise_error;
4521: end if;
4522: --
4523: close c224;

Line 6243: delete from BEN_PRTT_ENRT_ACTN_F

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;
6245:
6246: delete from BEN_PRTT_ENRT_CTFN_PRVDD_F
6247: where business_group_id = p_bg_id;