DBA Data[Home] [Help]

APPS.IEX_SCOREAPI_PUB SQL Statements

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

Line: 269

           SELECT  del_status
             FROM  iex_del_statuses
             WHERE P_SCORE between score_value_low and score_value_high
               AND  score_id = P_SCORE_ID;
Line: 565

        ' Select jtf_object_code ' ||
        ' From iex_scores ' ||
        ' where score_id = :p_score_id'
        into l_object_code
        using p_score_id;