APPS.PAY_ES_COURT_ORDER_DEDUCTION SQL Statements

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

Line: 15

    SELECT /*+ ORDERED*/ to_number(pur.row_low_range_or_name) Low_value
           ,to_number(pur.row_high_range) High_value
    FROM    pay_user_tables put
           ,pay_user_rows_f pur
    WHERE   put.user_table_name = 'ES_COURT_ORDER_DEDUCTION_SCALE'
    AND     put.user_table_id = pur.user_table_id
    AND     put.legislation_code = 'ES'
    AND     pur.legislation_code = 'ES'
    AND     (c_salary > to_number(pur.row_low_range_or_name) * c_wage
            OR c_salary BETWEEN to_number(pur.row_low_range_or_name) * c_wage
                            AND to_number(pur.row_high_range * c_wage))
    AND     c_effective_date between pur.effective_start_date AND pur.effective_end_date
    ORDER BY 1;