2864: l_job_id number;
2865: begin
2866: select job.job_id
2867: into l_job_id
2868: from per_jobs_vl job
2869: where job.name = p_job_name
2870: and job.business_group_id + 0 = p_business_group_id;
2871: return(l_job_id);
2872: exception
4059: l_ovn number;
4060: begin
4061: select job.object_version_number
4062: into l_ovn
4063: from per_jobs_vl job
4064: where job.name = p_job_name
4065: and job.business_group_id + 0 = p_business_group_id;
4066: return(l_ovn);
4067: exception