DBA Data[Home] [Help]

APPS.AP_PMT_VALIDATIONS_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 122: ap_supplier_sites_all aps,

118: SELECT COUNT(*) validation2
119: INTO l_int_inv_actual_count
120: FROM iby_fd_payments_v ibypmts,
121: iby_fd_docs_payable_v ibydocs,
122: ap_supplier_sites_all aps,
123: ap_selected_invoices_all apsi,
124: ap_invoices_all orig
125: WHERE ibypmts.payment_id = ibydocs.payment_id
126: AND ibypmts.completed_pmts_group_id = p_completed_pmts_group_id

Line 210: ap_supplier_sites_all aps

206: po_vendors pv,
207: ce_bank_acct_uses_all ce,
208: ce_gl_accounts_ccid cegl,
209: ce_bank_accounts ceb,
210: ap_supplier_sites_all aps
211: WHERE iby.inv_payee_party_id = pv.party_id(+)
212: AND aps.vendor_site_id(+) = iby.supplier_site_id
213: AND NVL(pv.vendor_id,-99) =
214: (SELECT