2891: l_job_id number;
2892: begin
2893: select job.job_id
2894: into l_job_id
2895: from per_jobs_vl job
2896: where job.name = p_job_name
2897: and job.business_group_id + 0 = p_business_group_id;
2898: return(l_job_id);
2899: exception
4086: l_ovn number;
4087: begin
4088: select job.object_version_number
4089: into l_ovn
4090: from per_jobs_vl job
4091: where job.name = p_job_name
4092: and job.business_group_id + 0 = p_business_group_id;
4093: return(l_ovn);
4094: exception