DBA Data[Home] [Help]

APPS.HR_PUMP_GET dependencies on PER_JOBS_VL

Line 2895: from per_jobs_vl job

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

Line 4090: from per_jobs_vl job

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