DBA Data[Home] [Help]

APPS.GHR_WGI_PKG dependencies on PER_GRADES

Line 308: CURSOR cur_wgi_no_payplan (p_grd_id per_grades.grade_id%TYPE)

304: SELECT 1
305: FROM fnd_sessions
306: WHERE session_id = USERENV ('sessionid');
307:
308: CURSOR cur_wgi_no_payplan (p_grd_id per_grades.grade_id%TYPE)
309: IS
310: SELECT gdf.segment1 pay_plan
311: FROM per_grades grd, per_grade_definitions gdf
312: WHERE grd.grade_id = p_grd_id

Line 311: FROM per_grades grd, per_grade_definitions gdf

307:
308: CURSOR cur_wgi_no_payplan (p_grd_id per_grades.grade_id%TYPE)
309: IS
310: SELECT gdf.segment1 pay_plan
311: FROM per_grades grd, per_grade_definitions gdf
312: WHERE grd.grade_id = p_grd_id
313: AND grd.grade_definition_id = gdf.grade_definition_id;
314:
315: l_ret_calc_perc NUMBER (15,3);