DBA Data[Home] [Help]

APPS.POS_PROFILE_PKG dependencies on IBY_EXTERNAL_PAYEES_ALL

Line 958: from iby_pmt_instr_uses_all uses, iby_external_payees_all payee, hz_party_sites hps

954: cursor l_bank_cur is
955: select uses.instrument_id, uses.order_of_preference, uses.start_date,
956: payee.supplier_site_id, payee.org_id, payee.org_type,
957: hps.party_id, uses.instrument_payment_use_id
958: from iby_pmt_instr_uses_all uses, iby_external_payees_all payee, hz_party_sites hps
959: where uses.instrument_type = 'BANKACCOUNT'
960: and payee.ext_payee_id = uses.ext_pmt_party_id
961: and payee.payee_party_id = hps.party_id
962: and payee.payment_function = 'PAYABLES_DISB'