265: l_dummy varchar2(1);
266: --
267: cursor c1 is
268: select null 269: from per_jobs abr 270: where abr.job_id = p_job_id
271: and abr.business_group_id = p_business_group_id
272: and p_effective_date
273: between date_from and nvl(date_to,hr_api.g_eot);