APPS.PER_QH_POPULATE dependencies on HR_ALL_POSITIONS_F

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 440: l_bargaining_unit hr_all_positions_f.bargaining_unit_cd%type;

436: l_salary_basis per_pay_bases.name%type;
437: l_pay_basis per_pay_bases.pay_basis%type;
438: l_payroll pay_all_payrolls_f.payroll_name%type;
439: l_supervisor per_all_people_f.full_name%type;
440: l_bargaining_unit hr_all_positions_f.bargaining_unit_cd%type;
441: l_dummy number;
442: --
443: cursor get_pos_defs is
444: select organization_id

Line 458: from hr_all_positions_f

454: , pay_freq_payroll_id
455: , supervisor_id
456: , entry_grade_id
457: , bargaining_unit_cd
458: from hr_all_positions_f
459: where position_id=p_position_id
460: and p_effective_date between effective_start_date and effective_end_date;
461: --
462: cursor get_vac is

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

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