DBA Data[Home] [Help]

APPS.AR_IREC_PAYMENTS dependencies on HZ_PARTIES

Line 1316: hz_parties hzcc,

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,
1320: fnd_territories_vl terr,

Line 1421: hz_parties hzcc,

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,
1423: hz_party_site_uses psu,
1424: hz_party_sites hps,
1425: hz_locations loc,

Line 5001: hz_parties bank,

4997: select pr.home_country into l_home_country
4998: from ar_cash_receipts_all cr,
4999: ce_bank_acct_uses bau,
5000: ce_bank_accounts cba,
5001: hz_parties bank,
5002: hz_organization_profiles pr
5003: where cr.cash_receipt_id = p_cash_receipt_id
5004: AND cr.remit_bank_acct_use_id = bau.bank_acct_use_id
5005: AND bau.bank_account_id = cba.bank_account_id