APPS.PER_QH_POPULATE dependencies on PER_JOBS

Line 80: l_job_name per_jobs.name%type;

76: function get_job
77: (p_job_id number) return varchar2 is
78: --
79: l_proc varchar2(72) :=g_package||'get_job';
80: l_job_name per_jobs.name%type;
81: --
82: cursor csr_job is
83: select name
84: from per_jobs_vl

Line 84: from per_jobs_vl

80: l_job_name per_jobs.name%type;
81: --
82: cursor csr_job is
83: select name
84: from per_jobs_vl
85: where job_id=p_job_id;
86: begin
87: --
88: hr_utility.set_location('Entering: '||l_proc,10);

Line 390: ,p_job OUT NOCOPY per_jobs.name%type

386: ,p_defaulting IN varchar2
387: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
388: ,p_organization OUT NOCOPY hr_organization_units.name%type
389: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
390: ,p_job OUT NOCOPY per_jobs.name%type
391: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
392: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
393: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
394: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type

Line 832: ,p_job OUT NOCOPY per_jobs.name%type

828: ,p_grade OUT NOCOPY per_grades.name%type
829: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type
830: ,p_position OUT NOCOPY hr_all_positions_f.name%type
831: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
832: ,p_job OUT NOCOPY per_jobs.name%type
833: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
834: ,p_location OUT NOCOPY hr_locations.location_code%type
835: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
836: ,p_organization OUT NOCOPY hr_organization_units.name%type