1068:
1069: cursor csr_jobs
1070: is
1071: select 'X' 1072: from per_jobs_v job 1073: where job.business_group_id +0 = p_business_group_id
1074: and p_effective_date between job.date_from and nvl(job.date_to, g_eot)
1075: and job.job_id = p_job_id;
1076: --