APPS.AP_PMT_VALIDATIONS_PKG dependencies on IBY_FD_DOCS_PAYABLE_V

Line 109: , iby_fd_docs_payable_v ibydocs

105:
106: select count(*)
107: into l_int_inv_expected_count
108: from ap_selected_invoices_all asi
109: , iby_fd_docs_payable_v ibydocs
110: where asi.original_invoice_id is not null
111: and ibydocs.calling_app_doc_unique_ref1 = TO_CHAR(asi.checkrun_id)
112: and ibydocs.calling_app_doc_unique_ref2 = TO_CHAR(asi.invoice_id)
113: and ibydocs.calling_app_doc_unique_ref3 = TO_CHAR(asi.payment_num)

Line 121: iby_fd_docs_payable_v ibydocs,

117:
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

Line 150: iby_fd_docs_payable_v ibydocs,

146:
147: SELECT COUNT(*) validation3
148: INTO l_int_line_actual_count
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

Line 249: FROM iby_fd_docs_payable_v

245:
246: --IBY_DOC_COUNT
247: SELECT COUNT(*) iby_doc_count
248: INTO l_iby_doc_count
249: FROM iby_fd_docs_payable_v
250: WHERE payment_id IN
251: (SELECT payment_id
252: FROM iby_payments_all
253: WHERE completed_pmts_group_id = p_completed_pmts_group_id

Line 261: iby_fd_docs_payable_v ibydocs,

257:
258: SELECT COUNT(*) ap_pmt_sch_count
259: INTO l_ap_pmtsch_count
260: FROM iby_fd_payments_v ibypmts,
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

Line 341: , iby_fd_docs_payable_v ibydocs

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
344: or ai.invoice_type_lookup_code = 'EXPENSE REPORT')
345: and ibydocs.calling_app_doc_unique_ref1 = TO_CHAR(apsi.checkrun_id)

Line 404: iby_fd_docs_payable_v ibydocs,

400: l_err_count:= 0;
401: SELECT COUNT(*)
402: INTO l_err_count
403: FROM iby_fd_payments_v ibypmts,
404: iby_fd_docs_payable_v ibydocs,
405: ap_selected_invoices_all SI,
406: ap_awt_temp_distributions_all atd
407: WHERE ibydocs.calling_app_doc_unique_ref1 = TO_CHAR(si.checkrun_id)
408: AND ibydocs.calling_app_doc_unique_ref2 = TO_CHAR(si.invoice_id)