114: -- This should return if there is a parent in different business group
115: -- If there is no parent business group id this should not return any rows
116: cursor c1 is
117: select null
118: from ben_rptg_grp bnr
119: where bnr.rptg_grp_id = p_rptg_grp_id
120: and nvl(bnr.business_group_id,p_business_group_id) <> p_business_group_id ;
121: --
122: Begin
122: Begin
123: --
124: hr_utility.set_location('Entering:'||l_proc,5);
125: --
126: -- check if rptg_grp_id value exists in ben_rptg_grp table
127: --
128: open c1;
129: --
130: fetch c1 into l_dummy;
182: l_dummy varchar2(1);
183: --
184: cursor c1 is
185: select null
186: from ben_rptg_grp a
187: where a.rptg_grp_id = p_rptg_grp_id;
188: --
189: Begin
190: --
208: if c1%notfound then
209: --
210: close c1;
211: --
212: -- raise error as FK does not relate to PK in ben_rptg_grp
213: -- table.
214: --
215: ben_cpy_shd.constraint_error('BEN_PL_REGN_FK2');
216: --