DBA Data[Home] [Help]

APPS.AP_PMT_CALLOUT_PKG dependencies on IBY_DOCS_PAYABLE_ALL

Line 1688: from ap_invoices_all inv,iby_docs_payable_all idp

1684: AND aps.vendor_site_id = iby.supplier_site_id -- 7673570
1685: AND pv.end_date_active IS NULL -- bug7166247
1686: --added condition as per Bug 7196023
1687: AND nvl(pv.vendor_id,-99) = (select decode(inv.invoice_type_lookup_code,'PAYMENT REQUEST',-99,nvl(vendor_id,-99)) --Bug7493630
1688: from ap_invoices_all inv,iby_docs_payable_all idp
1689: where inv.invoice_id=idp.calling_app_doc_unique_ref2
1690: and idp.payment_id=iby.payment_id
1691: and idp.calling_app_doc_unique_ref1=l_checkrun_id
1692: and rownum=1