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.GHR_SF52_API dependencies on HR_ALL_POSITIONS_F

Line 277: l_position_id hr_all_positions_f.position_id%type;

273: l_par_object_version_number ghr_pa_requests.object_version_number%TYPE;
274: l_rei_object_version_number ghr_pa_request_extra_info.object_version_number%TYPE;
275: l_pa_request_extra_info_id ghr_pa_request_extra_info.pa_request_extra_info_id%TYPE;
276: l_flag varchar2(1);
277: l_position_id hr_all_positions_f.position_id%type;
278: l_employee_id per_people_f.person_id%type;
279: l_approval_date date;
280: l_approving_official_work_titl ghr_pa_requests.approving_official_work_title%type;
281: l_approving_official_full_name ghr_pa_requests.approving_official_full_name%type;

Line 5039: from hr_all_positions_f pos

5035:
5036: --Bug# 9761810 Modified the cursor to consider Position all segments
5037: cursor c_det_pos_name(l_pos_id number) IS
5038: select pos.name pos_name
5039: from hr_all_positions_f pos
5040: where pos.position_id = l_pos_id
5041: and p_effective_date between pos.effective_start_date and pos.effective_end_date;
5042:
5043: cursor c_remk_desc is

Line 5056: l_detail_position_name hr_all_positions_f.name%type;

5052: l_detail_job_id ghr_pa_request_extra_info.rei_information7%TYPE;
5053: l_detail_location_id ghr_pa_request_extra_info.rei_information12%TYPE;
5054: l_detail_org ghr_pa_request_extra_info.rei_information13%TYPE;
5055:
5056: l_detail_position_name hr_all_positions_f.name%type;
5057: l_detail_grade PER_GRADES.name%type;
5058: l_detail_job HR_LOOKUPS.MEANING%type;
5059: l_detail_pay_plan ghr_pa_requests.from_pay_plan%type;
5060: l_detail_location varchar2(200);