DBA Data[Home] [Help]

APPS.AP_INVOICES_UTILITY_PKG dependencies on IBY_EXTERNAL_PAYEES_ALL

Line 3612: IBY_EXTERNAL_PAYEES_ALL ibypayee

3608: b.bank_account_number,
3609: rank() over (partition by ibyu.instrument_id, ibyu.instrument_type order by ibyu.instrument_payment_use_id) not_dup
3610: FROM IBY_PMT_INSTR_USES_ALL ibyu,
3611: IBY_EXT_BANK_ACCOUNTS_V b,
3612: IBY_EXTERNAL_PAYEES_ALL ibypayee
3613: WHERE ibyu.instrument_id = b.ext_bank_account_id
3614: AND ibyu.instrument_type = 'BANKACCOUNT'
3615: AND (b.currency_code = p_invoice_currency_code OR b.currency_code is null
3616: OR NVL(b.foreign_payment_use_flag,'N')='Y')