DBA Data[Home] [Help]

APPS.POS_BANK_ACCOUNT_BO_PKG dependencies on IBY_EXTERNAL_PAYEES_ALL

Line 119: iby_external_payees_all payee,

115: -- Part 1: Get all suppliers that own same bank account(s) with the current supplier (l_party_id)
116: (SELECT DISTINCT a1.account_owner_party_id,
117: a1.ext_bank_account_id
118: FROM iby_account_owners a1,
119: iby_external_payees_all payee,
120: iby_pmt_instr_uses_all instr
121: WHERE payee.ext_payee_id = instr.ext_pmt_party_id
122: AND payee_party_id = l_party_id
123: AND instr.instrument_id = a1.ext_bank_account_id