APPS.XDP_MESSAGE SQL Statements

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

Line: 32

    SELECT wf.notification_id, msg.msg_id, msg.msg_code
    FROM wf_notifications wf
       , xnp_msgs msg
    WHERE wf.message_name like 'MSG_FAILURE_NOTIF'
    AND wf.status = 'OPEN'
    AND msg.msg_code like p_msg_to_retry
    AND msg.msg_status = 'FAILED'
    AND TO_CHAR(msg.msg_id) =
                     SUBSTR(subject,INSTR(subject,' - ')+3,LENGTH(subject));