APPS.GHR_PA_REQUESTS_PKG2 dependencies on HR_ALL_POSITIONS_F

Line 235: FROM per_position_definitions pdf, hr_all_positions_f pos

231: RETURN VARCHAR2 IS
232: CURSOR cur_pp IS
233: --
234: SELECT pdf.segment3 nfc_agency
235: FROM per_position_definitions pdf, hr_all_positions_f pos
236: WHERE pos.position_id = p_position_id
237: AND p_effective_date between pos.effective_start_date
238: and pos.effective_end_date
239: AND pos.position_definition_id = pdf.position_definition_id;

Line 256: FROM per_position_definitions pdf, hr_all_positions_f pos

252: RETURN VARCHAR2 IS
253: CURSOR cur_pp(c_position_id IN NUMBER,c_effective_date IN DATE) IS
254: --
255: SELECT pdf.segment4 poi
256: FROM per_position_definitions pdf, hr_all_positions_f pos
257: WHERE pos.position_id = c_position_id
258: AND c_effective_date between pos.effective_start_date
259: and pos.effective_end_date
260: AND pos.position_definition_id = pdf.position_definition_id;

Line 278: from per_position_definitions ppd,hr_all_positions_f pos

274: RETURN VARCHAR2 IS
275: CURSOR cur_pp IS
276: --
277: select segment4 poi
278: from per_position_definitions ppd,hr_all_positions_f pos
279: where ppd.position_definition_id = pos.position_definition_id
280: and pos.position_id = p_position_id
281: and p_effective_date between pos.effective_start_date and
282: pos.effective_end_date;

Line 308: from per_position_definitions ppd,hr_all_positions_f pos

304: RETURN VARCHAR2 IS
305: CURSOR cur_pp IS
306: --
307: select segment3 nfc_agency
308: from per_position_definitions ppd,hr_all_positions_f pos
309: where ppd.position_definition_id = pos.position_definition_id
310: and pos.position_id = p_position_id
311: and p_effective_date between pos.effective_start_date
312: and pos.effective_end_date;

Line 339: from per_position_definitions ppd,hr_all_positions_f pos

335: --
336: CURSOR cur_pp(c_position_id IN NUMBER
337: ,c_effective_date in date) IS
338: select segment7 grade_id
339: from per_position_definitions ppd,hr_all_positions_f pos
340: where ppd.position_definition_id = pos.position_definition_id
341: and pos.position_id = p_position_id
342: and p_effective_date between pos.effective_start_date
343: and pos.effective_end_date;

Line 377: from per_position_definitions ppd,hr_all_positions_f pos

373: FROM per_grade_definitions gdf
374: ,per_grades grd
375: WHERE grd.grade_id in
376: (select segment7
377: from per_position_definitions ppd,hr_all_positions_f pos
378: where ppd.position_definition_id = pos.position_definition_id
379: and pos.position_id = p_position_id
380: and p_effective_date between pos.effective_start_date and
381: pos.effective_end_date)

Line 741: from hr_all_positions_f pos, per_shared_types typ

737: l_message_set BOOLEAN := FALSE;
738:
739: cursor cur_pos is
740: select pos.effective_start_date,pos.effective_end_date,typ.system_type_cd status
741: from hr_all_positions_f pos, per_shared_types typ
742: where p_effective_date
743: between pos.effective_start_date and pos.effective_end_date
744: and pos.business_group_id = p_business_group_id
745: and pos.position_id = p_position_id

Line 749: from hr_all_positions_f pos1, per_shared_types typ1

745: and pos.position_id = p_position_id
746: and pos.availability_status_id = typ.shared_type_id
747: union
748: select pos1.effective_start_date,pos1.effective_end_date,typ1.system_type_cd status
749: from hr_all_positions_f pos1, per_shared_types typ1
750: where p_effective_date <= pos1.effective_start_date
751: and pos1.business_group_id = p_business_group_id
752: and pos1.position_id = p_position_id
753: and pos1.availability_status_id = typ1.shared_type_id

Line 807: from hr_all_positions_f pos, per_shared_types typ

803: l_message_set BOOLEAN := FALSE;
804:
805: cursor cur_pos is
806: select effective_start_date,effective_end_date,system_type_cd status
807: from hr_all_positions_f pos, per_shared_types typ
808: where p_effective_date
809: between effective_start_date and effective_end_date
810: and position_id = p_position_id
811: and pos.business_group_id = p_business_group_id