185: l_dummy varchar2(1);
186: --
187: cursor c1 is
188: select null 189: from per_job_groups grp 190: where grp.job_group_id = p_job_group_id;
191: --
192: Begin
193: --
Line 208: -- per_job_groups table
204: or not l_api_updating)
205: and p_job_group_id is not null then
206: --
207: -- check if job_group_id value exists in 208: -- per_job_groups table 209: --
210: open c1;
211: --
212: fetch c1 into l_dummy;