APPS.POS_MERGE_SUPPLIER_PKG dependencies on IBY_EXTERNAL_PAYEES_ALL

Line 776: FROM iby_external_payees_all

772: WHERE lookup_type = 'IBY_PAYMENT_FLOW'
773: AND language = userenv('LANG'))
774: AND ext_pmt_party_id IN
775: (SELECT ext_payee_id
776: FROM iby_external_payees_all
777: WHERE payee_party_id = p_from_party
778: AND org_id IS NULL
779: AND party_site_id IS NULL
780: AND supplier_site_id IS NULL)

Line 784: FROM iby_external_payees_all extpayee,

780: AND supplier_site_id IS NULL)
781: AND /* Excluding the accounts that are already associated*/
782: paymentinstrumentuseseo.instrument_id NOT IN
783: (SELECT instrument_id
784: FROM iby_external_payees_all extpayee,
785: iby_pmt_instr_uses_all instr
786: WHERE extpayee.payee_party_id = p_to_party
787: AND extpayee.org_id IS NULL
788: AND extpayee.party_site_id IS NULL