APPS.PQH_BUDGET_ANALYSIS_PKG dependencies on HR_ALL_POSITIONS_F

Line 40: hr_all_positions_f_vl pos

36: cursor c_positions(p_organization_id number, p_effective_date date) is
37: select
38: pos.position_id, pos.job_id, name
39: from
40: hr_all_positions_f_vl pos
41: where
42: pos.organization_id = p_organization_id
43: and p_effective_date between pos.effective_start_date and pos.effective_end_date
44: order by position_id;

Line 137: from hr_all_positions_f psf

133: select user_name
134: from fnd_user
135: where employee_id =
136: (select psf.supervisor_id
137: from hr_all_positions_f psf
138: where psf.position_id = p_position_id
139: and l_effective_date >= psf.effective_start_date
140: and l_effective_date <= psf.effective_end_date
141: );

Line 675: from hr_all_positions_f_vl pos

671: --
672: -- PMFLETCH Now selects from MLS view
673: cursor c_positions(p_organization_id number, p_effective_date date) is
674: select pos.position_id, pos.job_id, name
675: from hr_all_positions_f_vl pos
676: where pos.organization_id = p_organization_id
677: and p_effective_date between pos.effective_start_date and pos.effective_end_date
678: order by position_id;
679: --

Line 687: from hr_all_positions_f psf

683: select user_name
684: from fnd_user
685: where employee_id =
686: (select psf.supervisor_id
687: from hr_all_positions_f psf
688: where psf.position_id = p_position_id
689: and p_effective_date >= psf.effective_start_date
690: and p_effective_date <= psf.effective_end_date
691: );