DBA Data[Home] [Help]

APPS.GHR_PA_REQUESTS_PKG2 dependencies on PER_GRADE_DEFINITIONS

Line 373: FROM per_grade_definitions gdf

369: RETURN VARCHAR2 IS
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

Line 405: FROM per_grade_definitions gdf

401: FUNCTION get_pay_plan (p_position_id IN NUMBER)
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'

Line 426: FROM per_grade_definitions gdf

422: RETURN VARCHAR2 IS
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'