21:
22: CURSOR csr_get_grade_value IS
23: SELECT pg.value
24: FROM pay_rates pr
25: ,pay_grade_rules_f pg
26: WHERE pr.rate_type= 'G'
27: AND pr.rate_id = p_rate_id
28: AND pr.rate_id = pg.rate_id
29: AND pg.grade_or_spinal_point_id = l_grade_id
77:
78: CURSOR csr_get_grade_value IS
79: SELECT pg.value
80: FROM pay_rates pr
81: ,pay_grade_rules_f pg
82: WHERE pr.rate_type= 'G'
83: AND pr.name = p_rate_table
84: AND pr.rate_id = pg.rate_id
85: AND pg.grade_or_spinal_point_id = l_grade_id