DBA Data[Home] [Help]

APPS.ASO_PAYMENT_INT dependencies on HZ_PARTIES

Line 720: hz_parties hzcc,

716: iby_creditcard_issuers_vl i,
717: iby_external_payers_all p,
718: iby_ext_bank_accounts_v b,
719: iby_pmt_instr_uses_all u,
720: hz_parties hzcc,
721: IBY_TRXN_EXTENSIONS_V t
722: WHERE(u.ext_pmt_party_id = p.ext_payer_id)
723: AND(decode(u.instrument_type, 'CREDITCARD', u.instrument_id, 'DEBITCARD', u.instrument_id, NULL) = c.instrid(+))
724: AND(decode(u.instrument_type, 'BANKACCOUNT', u.instrument_id, NULL) = b.bank_account_id(+))