APPS.BEN_PRB_BUS dependencies on BEN_RPTG_GRP

Line 116: from ben_rptg_grp a

112: l_dummy varchar2(1);
113: --
114: cursor c1 is
115: select null
116: from ben_rptg_grp a
117: where a.rptg_grp_id = p_rptg_grp_id;
118: --
119: Begin
120: --

Line 134: -- check if rptg_grp_id value exists in ben_rptg_grp table

130: <> nvl(ben_prb_shd.g_old_rec.rptg_grp_id,hr_api.g_number)
131: or not l_api_updating) and
132: p_rptg_grp_id is not null then
133: --
134: -- check if rptg_grp_id value exists in ben_rptg_grp table
135: --
136: open c1;
137: --
138: fetch c1 into l_dummy;

Line 143: -- raise error as FK does not relate to PK in ben_rptg_grp

139: if c1%notfound then
140: --
141: close c1;
142: --
143: -- raise error as FK does not relate to PK in ben_rptg_grp
144: -- table.
145: --
146: ben_prb_shd.constraint_error('BEN_PL_REGY_BOD_FK1');
147: --

Line 197: from ben_rptg_grp bnr

193: -- This should return if there is a parent in different business group
194: -- If there is no parent business group id this should not return any rows
195: cursor c1 is
196: select null
197: from ben_rptg_grp bnr
198: where bnr.rptg_grp_id = p_rptg_grp_id
199: and nvl(bnr.business_group_id,p_business_group_id) <> p_business_group_id ;
200: --
201: Begin

Line 205: -- check if rptg_grp_id value exists in ben_rptg_grp table

201: Begin
202: --
203: hr_utility.set_location('Entering:'||l_proc,5);
204: --
205: -- check if rptg_grp_id value exists in ben_rptg_grp table
206: --
207: open c1;
208: --
209: fetch c1 into l_dummy;

Line 294: -- raise error as FK does not relate to PK in ben_rptg_grp

290: --
291: close c1;
292: --
293: --
294: -- raise error as FK does not relate to PK in ben_rptg_grp
295: -- table.
296: --
297: ben_prb_shd.constraint_error('BEN_PL_REGY_BOD_FK1');
298: --