DBA Data[Home] [Help]

APPS.FV_FEDERAL_PAYMENT_FIELDS_PKG dependencies on IBY_DOCS_PAYABLE_ALL

Line 168: iby_docs_payable_all idpa,

164: CURSOR invoice_dist_csr
165: IS
166: SELECT DISTINCT aid.dist_code_combination_id
167: FROM iby_payments_all ipa,
168: iby_docs_payable_all idpa,
169: ap_invoice_distributions aid
170: WHERE ipa.payment_id = p_payment_id
171: and ipa.payment_id = idpa.payment_id
172: and idpa.calling_app_id = 200

Line 229: iby_docs_payable_all idpa,

225:
226: select aia.vendor_id, aia.vendor_site_id, aps.vendor_type_lookup_code
227: into l_vendor_id, l_vendor_site_id, l_vendor_type
228: from iby_payments_all ipa,
229: iby_docs_payable_all idpa,
230: ap_invoices_all aia,
231: ap_suppliers aps
232: where ipa.payment_id = p_payment_id
233: and ipa.payment_id = idpa.payment_id