APPS.IBY_CC_VALIDATE SQL Statements

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

Line: 440

      SELECT cc_issuer_range_id, r.card_issuer_code,
        card_number_prefix, NVL(digit_check_flag,'N')
      FROM iby_cc_issuer_ranges r, iby_creditcard_issuers_b i
      WHERE (card_number_length = ci_card_len)
        AND (INSTR(ci_card_number,card_number_prefix) = 1)
        AND (r.card_issuer_code = i.card_issuer_code)
	AND r.card_issuer_code = NVL(ci_card_type, r.card_issuer_code)
        ORDER BY r.last_updated_by DESC,
	  r.last_update_date DESC;