APPS.GHR_WGI_PKG dependencies on PER_GRADE_DEFINITIONS

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);

Line 317: l_per_pay_plan per_grade_definitions.segment1%TYPE;

313: AND grd.grade_definition_id = gdf.grade_definition_id;
314:
315: l_ret_calc_perc NUMBER (15,3);
316: l_new_retention_allowance NUMBER;
317: l_per_pay_plan per_grade_definitions.segment1%TYPE;
318: l_from_pay_table_identifier ghr_pa_requests.from_pay_table_identifier%TYPE;
319: -- Sun 4490539
320: l_check_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
321: l_check_step_or_rate ghr_pa_requests.to_step_or_rate%type;