APPS.AP_PMT_VALIDATIONS_PKG dependencies on AP_INVOICES_ALL

Line 124: ap_invoices_all orig

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
127: --AND ibypmts.org_id = :l_current_org_id
128: AND ibypmts.org_type = 'OPERATING_UNIT'

Line 153: ap_invoices_all orig

149: FROM iby_fd_payments_v ibypmts,
150: iby_fd_docs_payable_v ibydocs,
151: po_vendors pv,
152: ap_selected_invoices_all apsi,
153: ap_invoices_all orig
154: WHERE ibypmts.payment_id = ibydocs.payment_id
155: AND ibypmts.completed_pmts_group_id = p_completed_pmts_group_id
156: --AND ibypmts.org_id = :l_current_org_id
157: AND ibypmts.org_type = 'OPERATING_UNIT'

Line 221: FROM ap_invoices_all inv,

217: AND SIGN(inv.vendor_id) = -1
218: THEN NVL(pv.vendor_id, -99)
219: ELSE NVL(vendor_id, -99)
220: END
221: FROM ap_invoices_all inv,
222: iby_docs_payable_all idp
223: WHERE inv.invoice_id =idp.calling_app_doc_unique_ref2
224: AND idp.payment_id =iby.payment_id
225: AND idp.payment_service_request_id = iby.payment_service_request_id

Line 265: ap_invoices_all AI

261: iby_fd_docs_payable_v ibydocs,
262: ap_selected_invoices_all SI,
263: fnd_currencies FORE,
264: ap_payment_schedules_all PS,
265: ap_invoices_all AI
266: WHERE ibydocs.calling_app_doc_unique_ref1 = TO_CHAR(si.checkrun_id)
267: AND ibydocs.calling_app_doc_unique_ref2 = TO_CHAR(si.invoice_id)
268: AND ibydocs.calling_app_doc_unique_ref3 = TO_CHAR(si.payment_num)
269: AND ibypmts.payment_id = ibydocs.payment_id

Line 339: from ap_invoices_all ai

335: IF (nvl(l_sse_cc_payment_notify,'N') = 'Y') then
336:
337: select count(*)
338: into l_err_count
339: from ap_invoices_all ai
340: , ap_selected_invoices_all apsi
341: , iby_fd_docs_payable_v ibydocs
342: where ai.source in ( 'Both Pay')
343: and (nvl(ai.paid_on_behalf_employee_id, -1) <> -1