APPS.GHR_PA_REQUESTS_PKG2 dependencies on PER_POSITION_DEFINITIONS

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)