376: AND grade_rule_id = l_grade_rule_id;
377:
378: Cursor C_payscale is
379: SELECT parent_spine_id
380: FROM PER_SPINAL_POINTS
381: WHERE spinal_point_id = l_grade_or_spinal_point_id
382: AND business_group_id = p_business_group_id;
383:
384: Cursor C_pay_basis is
1063: AND psp.spinal_point_id = l_grade_or_spinal_point_id;
1064: --
1065: Cursor C_payscale is
1066: SELECT parent_spine_id
1067: FROM PER_SPINAL_POINTS
1068: WHERE spinal_point_id = l_grade_or_spinal_point_id
1069: AND business_group_id = p_business_group_id;
1070: --
1071: Cursor C_payname is