eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_QH_POPULATE dependencies on HR_ALL_POSITIONS

Line 109: l_position_name hr_all_positions.name%type;

105: (p_position_id number
106: ,p_effective_date date) return varchar2 is
107: --
108: l_proc varchar2(72) :=g_package||'get_position';
109: l_position_name hr_all_positions.name%type;
110: --
111: -- PMFLETCH - MLS enabled name
112: --
113: cursor csr_position is

Line 115: from hr_all_positions_f_tl

111: -- PMFLETCH - MLS enabled name
112: --
113: cursor csr_position is
114: select name
115: from hr_all_positions_f_tl
116: where position_id=p_position_id
117: and language = userenv('LANG');
118: -- PMFLETCH - Effective date no longer used, MLS name is always eot value
119: --and p_effective_date between effective_start_date and effective_end_date;

Line 447: l_bargaining_unit hr_all_positions_f.bargaining_unit_cd%type;

443: l_salary_basis per_pay_bases.name%type;
444: l_pay_basis per_pay_bases.pay_basis%type;
445: l_payroll pay_all_payrolls_f.payroll_name%type;
446: l_supervisor per_all_people_f.full_name%type;
447: l_bargaining_unit hr_all_positions_f.bargaining_unit_cd%type;
448: l_dummy number;
449: --
450: cursor get_pos_defs is
451: select organization_id

Line 465: from hr_all_positions_f

461: , pay_freq_payroll_id
462: , supervisor_id
463: , entry_grade_id
464: , bargaining_unit_cd
465: from hr_all_positions_f
466: where position_id=p_position_id
467: and p_effective_date between effective_start_date and effective_end_date;
468: --
469: cursor get_vac is

Line 837: ,p_position OUT NOCOPY hr_all_positions_f.name%type

833: ,p_recruiter OUT NOCOPY per_all_people_f.full_name%type
834: ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%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