APPS.WSH_CC_RESPONSE_PKG SQL Statements

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

Line: 58

    SELECT response_header_id, c.error_code, interpreted_value_code
    FROM WSH_CC_TRANS_CONTROL c, WSH_GTC_RESPONSE_RULES r
    WHERE transaction_control_id = trans_control_id and c.error_code = r.error_code(+) ;

Line: 64

    SELECT l.error_code error_code, l.error_type error_type,
              denied_party_flag, embargo_flag, license_required
    FROM WSH_CC_RESPONSE_LINES l
    WHERE response_header_id = resp_header_id;

Line: 70

    SELECT interpreted_value_code
    FROM WSH_GTC_RESPONSE_RULES
    WHERE error_type = p_error_type and nvl(error_code,p_error_code) = p_error_code
    ORDER BY error_code;