2160: --
2161: cursor csr_check_job is
2162: select 1
2163: from per_jobs job, 2164: per_job_groups jgr 2165: where job.job_id = p_job_id
2166: and p_start_date between job.date_from and nvl(job.date_to,hr_api.g_eot)
2167: and job.job_group_id = jgr.job_group_id
2168: and jgr.internal_name = 'HR_'||jgr.business_group_id
[Home] [Help]