APPS.BEN_ORG_DELETE dependencies on BEN_PRTT_ENRT_CTFN_PRVDD_F

Line 898: is select 1 from BEN_PRTT_ENRT_CTFN_PRVDD_F

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
899: where business_group_id = p_bg_id;
900:
901: cursor c226(p_bg_id NUMBER)
902: is select 1 from BEN_ELIG_DPNT

Line 4526: -- Testing for values in BEN_PRTT_ENRT_CTFN_PRVDD_F

4522: --
4523: close c224;
4524:
4525: --
4526: -- Testing for values in BEN_PRTT_ENRT_CTFN_PRVDD_F
4527: --
4528: open c225(p_bg_id);
4529: --
4530: fetch c225 into l_temp;

Line 4534: fnd_message.set_token('TABLE_NAME','BEN_PRTT_ENRT_CTFN_PRVDD_F');

4530: fetch c225 into l_temp;
4531: if c225%found then
4532: close c225;
4533: fnd_message.set_name('BEN','HR_7215_DT_CHILD_EXISTS');
4534: fnd_message.set_token('TABLE_NAME','BEN_PRTT_ENRT_CTFN_PRVDD_F');
4535: fnd_message.raise_error;
4536: end if;
4537: --
4538: close c225;

Line 6246: delete from BEN_PRTT_ENRT_CTFN_PRVDD_F

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;
6248:
6249: delete from BEN_ELIG_DPNT
6250: where business_group_id = p_bg_id;