eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_IREC_PAYMENTS dependencies on IBY_CC_ISSUER_RANGES

Line 239: l_issuer_range iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;

235:
236: -- arp_standard.debug(' p_credit_card_number :' || p_credit_card_number);
237:
238: l_card_issuer iby_creditcard_issuers_b.card_issuer_code%TYPE;
239: l_issuer_range iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;
240: l_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
241: l_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
242:
243: CURSOR c_range

Line 240: l_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;

236: -- arp_standard.debug(' p_credit_card_number :' || p_credit_card_number);
237:
238: l_card_issuer iby_creditcard_issuers_b.card_issuer_code%TYPE;
239: l_issuer_range iby_cc_issuer_ranges.cc_issuer_range_id%TYPE;
240: l_card_prefix iby_cc_issuer_ranges.card_number_prefix%TYPE;
241: l_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;
242:
243: CURSOR c_range
244: (ci_card_number IN iby_creditcard.ccnumber%TYPE,

Line 249: FROM iby_cc_issuer_ranges r, iby_creditcard_issuers_b i

245: ci_card_len IN NUMBER)
246: IS
247: SELECT cc_issuer_range_id, r.card_issuer_code,
248: card_number_prefix, NVL(digit_check_flag,'N')
249: FROM iby_cc_issuer_ranges r, iby_creditcard_issuers_b i
250: WHERE (card_number_length = ci_card_len)
251: AND (INSTR(ci_card_number,card_number_prefix) = 1)
252: AND (r.card_issuer_code = i.card_issuer_code);
253: BEGIN