APPS.AR_IREC_PAYMENTS dependencies on IBY_CREDITCARD

Line 238: l_card_issuer iby_creditcard_issuers_b.card_issuer_code%TYPE;

234: -- arp_standard.debug('AR_IREC_PAYMENTS.get_credit_card_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:

Line 241: l_digit_check iby_creditcard_issuers_b.digit_check_flag%TYPE;

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,
245: ci_card_len IN NUMBER)

Line 244: (ci_card_number IN iby_creditcard.ccnumber%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,
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')

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

Line 1417: iby_creditcard c,

1413: NULL branch_party_id,
1414: NULL object_version_number
1415: FROM
1416: fnd_lookup_values_vl ccunk,
1417: iby_creditcard c,
1418: iby_creditcard_issuers_vl i,
1419: iby_external_payers_all p,
1420: iby_pmt_instr_uses_all u,
1421: hz_parties hzcc,

Line 1418: iby_creditcard_issuers_vl i,

1414: NULL object_version_number
1415: FROM
1416: fnd_lookup_values_vl ccunk,
1417: iby_creditcard c,
1418: iby_creditcard_issuers_vl i,
1419: iby_external_payers_all p,
1420: iby_pmt_instr_uses_all u,
1421: hz_parties hzcc,
1422: hz_cust_accounts cust,

Line 1888: CURSOR cc_cur(p_instrument_id iby_creditcard.instrid%TYPE) is

1884: FUNCTION is_bank_account_duplicate(p_bank_account_number IN VARCHAR2,
1885: p_routing_number IN VARCHAR2 DEFAULT NULL,
1886: p_account_holder_name IN VARCHAR2) RETURN NUMBER IS
1887:
1888: CURSOR cc_cur(p_instrument_id iby_creditcard.instrid%TYPE) is
1889: SELECT count(1) ca_exists
1890: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V IBY
1891: WHERE IBY.instrument_id = p_instrument_id
1892: AND IBY.CARD_HOLDER_NAME <> p_account_holder_name;