APPS.AR_IREC_PAYMENTS dependencies on IBY_FNDCPT_PAYER_ASSGN_INSTR_V

Line 595: iby_fndcpt_payer_assgn_instr_v

591: ( arc.creation_method_code = 'AUTOMATIC' and
592: --Bug 4947418: Modified the following query as ar_customer_bank_accounts_v
593: --has been obsoleted in r12.
594: p_currcode in (select currency_code from
595: iby_fndcpt_payer_assgn_instr_v
596: where party_id=p_customer_id)))
597: */
598:
599:

Line 926: from IBY_FNDCPT_PAYER_ASSGN_INSTR_V

922: CURSOR instr_details(p_bank_account_id IN NUMBER,
923: l_party_id IN NUMBER,
924: l_customer_site_id IN NUMBER) IS
925: select org_id,instr_assignment_id,assignment_start_date,acct_site_use_id
926: from IBY_FNDCPT_PAYER_ASSGN_INSTR_V
927: where INSTRUMENT_ID = p_bank_account_id AND PARTY_ID = l_party_id
928: AND((l_customer_site_id IS NOT NULL AND ACCT_SITE_USE_ID = l_customer_site_id ) OR (l_customer_site_id IS NULL AND ACCT_SITE_USE_ID IS NULL));
929:
930: l_create_credit_card IBY_FNDCPT_SETUP_PUB.CreditCard_rec_type;

Line 1002: from IBY_FNDCPT_PAYER_ASSGN_INSTR_V

998: OPEN instr_details(p_bank_account_id,l_party_id,l_customer_site_id);
999: IF (instr_details%NOTFOUND) THEN
1000: select org_id,instr_assignment_id,assignment_start_date,acct_site_use_id
1001: into l_org_id,l_instr_assignment_id,l_assignment_start_date,l_acct_site_use_id
1002: from IBY_FNDCPT_PAYER_ASSGN_INSTR_V
1003: where INSTRUMENT_ID = p_bank_account_id AND PARTY_ID = l_party_id
1004: AND ACCT_SITE_USE_ID IS NULL;
1005: CLOSE instr_details;
1006: ELSE

Line 1315: IBY_FNDCPT_PAYER_ASSGN_INSTR_V c,

1311: NULL object_version_number
1312: FROM hz_cust_accounts cust,
1313: hz_party_preferences pp1,
1314: iby_external_payers_all p,
1315: IBY_FNDCPT_PAYER_ASSGN_INSTR_V c,
1316: hz_parties hzcc,
1317: hz_party_site_uses psu,
1318: hz_party_sites hps,
1319: hz_locations loc,

Line 1890: FROM IBY_FNDCPT_PAYER_ASSGN_INSTR_V IBY

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;
1893:
1894: CURSOR ba_cur IS