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 397: ,p_job OUT NOCOPY per_jobs.name%type

393: ,p_defaulting IN varchar2
394: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
395: ,p_organization OUT NOCOPY hr_organization_units.name%type
396: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
397: ,p_job OUT NOCOPY per_jobs.name%type
398: ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
399: ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
400: ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
401: ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type

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

835: ,p_grade OUT NOCOPY per_grades.name%type
836: ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type
837: ,p_position OUT NOCOPY hr_all_positions_f.name%type
838: ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
839: ,p_job OUT NOCOPY per_jobs.name%type
840: ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
841: ,p_location OUT NOCOPY hr_locations.location_code%type
842: ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
843: ,p_organization OUT NOCOPY hr_organization_units.name%type