DBA Data[Home] [Help]

APPS.PE_GET_VAL_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

      SELECT g.MINIMUM, g.mid_value, g.maximum
        FROM pay_grade_rules_f g
       WHERE g.grade_or_spinal_point_id = g_grade_id
         AND g.rate_id = g_rate_id
         AND g_change_date BETWEEN g.effective_start_date AND g.effective_end_date;