DBA Data[Home] [Help]

APPS.HR_PDT_BUS dependencies on PER_JOBS

Line 2163: from per_jobs job,

2159: l_dummy number;
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