APPS.BEN_RGR_BUS dependencies on BEN_RPTG_GRP

Line 118: from ben_rptg_grp bnr

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

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

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;

Line 186: from ben_rptg_grp a

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: --

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

201: or not l_api_updating)
202: -- and p_rptg_grp_id is not null /* Moved the check condition below bug 2690186 */
203: then
204: --
205: -- check if rptg_grp_id value exists in ben_rptg_grp table
206: --
207: if p_rptg_grp_id is null then
208:
209: fnd_message.set_name('BEN','BEN_93266_RPTG_GRP_NAME_NULL');

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

217: if c1%notfound then
218: --
219: close c1;
220: --
221: -- raise error as FK does not relate to PK in ben_rptg_grp
222: -- table.
223: --
224: ben_rgr_shd.constraint_error('BEN_POPL_RPTG_GRP_FK1');
225: --

Line 295: from ben_rptg_grp

291: and p_validate_end_date >= effective_start_date;
292: --iRec
293: cursor crs_rptg_prps is
294: select rptg_prps_cd
295: from ben_rptg_grp
296: where rptg_grp_id = p_rptg_grp_id;
297: --
298: cursor crs_irec_pln is
299: select null