APPS.GHR_PA_REQUESTS_PKG2 dependencies on PER_GRADES

Line 345: CURSOR get_pay_plan(c_grade_id per_grades.grade_id%type) IS

341: and pos.position_id = p_position_id
342: and p_effective_date between pos.effective_start_date
343: and pos.effective_end_date;
344:
345: CURSOR get_pay_plan(c_grade_id per_grades.grade_id%type) IS
346: select name grade_name
347: from per_grades
348: where grade_id = c_grade_id;
349:

Line 347: from per_grades

343: and pos.effective_end_date;
344:
345: CURSOR get_pay_plan(c_grade_id per_grades.grade_id%type) IS
346: select name grade_name
347: from per_grades
348: where grade_id = c_grade_id;
349:
350: l_grade_id per_grades.grade_id%type;
351:

Line 350: l_grade_id per_grades.grade_id%type;

346: select name grade_name
347: from per_grades
348: where grade_id = c_grade_id;
349:
350: l_grade_id per_grades.grade_id%type;
351:
352: BEGIN
353: FOR cur_pp_rec IN cur_pp(p_position_id
354: ,p_effective_date) LOOP

Line 374: ,per_grades grd

370: CURSOR cur_pp IS
371: --
372: SELECT gdf.segment1 || '-' || gdf.segment2 pay_plan
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

Line 406: ,per_grades grd

402: RETURN VARCHAR2 IS
403: CURSOR cur_pp IS
404: SELECT gdf.segment1 pay_plan
405: FROM per_grade_definitions gdf
406: ,per_grades grd
407: ,per_position_extra_info poi
408: WHERE poi.position_id = p_position_id
409: AND poi.information_type = 'GHR_US_POS_VALID_GRADE'
410: AND grd.grade_id = poi.poei_information3

Line 427: ,per_grades grd

423: --
424: CURSOR cur_pp IS
425: SELECT gdf.segment2 grade_or_level
426: FROM per_grade_definitions gdf
427: ,per_grades grd
428: ,per_position_extra_info poi
429: WHERE poi.position_id = p_position_id
430: AND poi.information_type = 'GHR_US_POS_VALID_GRADE'
431: AND grd.grade_id = poi.poei_information3