APPS.AR_IREC_PAYMENTS dependencies on IBY_CC_ISSUER_RANGES

Line 233: l_issuer_range iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;

229:
230: -- arp_standard.debug(' p_credit_card_number :' || p_credit_card_number);
231:
232: l_card_issuer iby_creditcard_issuers_b.card_issuer_code%TYPE;
233: l_issuer_range iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;
234: l_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
235: l_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
236:
237: CURSOR c_range

Line 234: l_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;

230: -- arp_standard.debug(' p_credit_card_number :' || p_credit_card_number);
231:
232: l_card_issuer iby_creditcard_issuers_b.card_issuer_code%TYPE;
233: l_issuer_range iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;
234: l_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
235: l_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
236:
237: CURSOR c_range
238: (ci_card_number IN iby_creditcard.ccnumber%TYPE,

Line 243: FROM iby_cc_issuer_ranges r, iby_creditcard_issuers_b i

239: ci_card_len IN NUMBER)
240: IS
241: SELECT cc_issuer_range_id, r.card_issuer_code,
242: card_number_prefix, NVL(digit_check_flag,'N')
243: FROM iby_cc_issuer_ranges r, iby_creditcard_issuers_b i
244: WHERE (card_number_length = ci_card_len)
245: AND (INSTR(ci_card_number,card_number_prefix) = 1)
246: AND (r.card_issuer_code = i.card_issuer_code);
247: BEGIN