DBA Data[Home] [Help]

APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on IBY_EXTERNAL_PAYEES_ALL

Line 4375: FROM iby_external_payees_all payee,

4371: CURSOR l_payee_defaulting_cur (p_payment_id NUMBER) IS
4372: SELECT payee.remit_advice_delivery_method,
4373: payee.remit_advice_email,
4374: payee.remit_advice_fax
4375: FROM iby_external_payees_all payee,
4376: iby_payments_all pmt
4377: WHERE payee.payee_party_id = pmt.payee_party_id
4378: AND payee.payment_function = pmt.payment_function
4379: AND (payee.org_id is NULL OR (payee.org_id = pmt.org_id AND payee.org_type = pmt.org_type))

Line 5877: iby_external_payees_all payee

5873: c_ext_bank_account_id NUMBER) is
5874: SELECT instr.instrument_payment_use_id, instr.attribute_category
5875: FROM iby_pmt_instr_uses_all instr,
5876: iby_payments_all pmt,
5877: iby_external_payees_all payee
5878: WHERE instr.instrument_id = c_ext_bank_account_id
5879: AND InStr.instrument_type = 'BANKACCOUNT'
5880: AND InStr.payment_flow = 'DISBURSEMENTS'
5881: AND pmt.payment_id = c_payment_id