APPS.AP_PMT_VALIDATIONS_PKG dependencies on IBY_FD_PAYMENTS_V

Line 39: FROM iby_fd_payments_v pmt,

35: SELECT pmt.payment_id,
36: ins.payment_document_id,
37: pmt.payment_method_code,
38: ce.bank_acct_use_id
39: FROM iby_fd_payments_v pmt,
40: iby_pay_instructions_all ins,
41: iby_payment_profiles ipp,
42: ce_bank_acct_uses_all ce
43: WHERE pmt.completed_pmts_group_id = p_completed_pmts_group_id

Line 81: FROM iby_fd_payments_v pmts

77: --http://ebizapdev.idc.oracle.com/iby/archive/Bugs/ap-iby-completion/validation1.txt
78:
79: SELECT COUNT(*) validation1
80: INTO l_err_count
81: FROM iby_fd_payments_v pmts
82: WHERE pmts.completed_pmts_group_id = p_completed_pmts_group_id
83: AND NOT EXISTS
84: (SELECT 1
85: FROM ap_system_parameters_all asp,

Line 120: FROM iby_fd_payments_v ibypmts,

116: /* Number of interest invoices that will actually be created */
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

Line 149: FROM iby_fd_payments_v ibypmts,

145: --http://ebizapdev.idc.oracle.com/iby/archive/Bugs/ap-iby-completion/validation3.txt
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

Line 199: FROM iby_fd_payments_v

195:
196: --IBY_CHECK_COUNT
197: SELECT COUNT(*) iby_check_count
198: INTO l_iby_pmt_count
199: FROM iby_fd_payments_v
200: WHERE completed_pmts_group_id = p_completed_pmts_group_id;
201: --AP_CHECK_COUNT
202: --(almost near to the original)
203: SELECT COUNT(*) ap_check_count

Line 205: FROM iby_fd_payments_v iby,

201: --AP_CHECK_COUNT
202: --(almost near to the original)
203: SELECT COUNT(*) ap_check_count
204: INTO l_ap_pmt_count
205: FROM iby_fd_payments_v iby,
206: po_vendors pv,
207: ce_bank_acct_uses_all ce,
208: ce_gl_accounts_ccid cegl,
209: ce_bank_accounts ceb,

Line 260: FROM iby_fd_payments_v ibypmts,

256: --PAYMENT_SCHEDULE and SELECTED INVOICE COUNT
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,

Line 384: , iby_fd_payments_v ibypmts

380: ELSE 1
381: END) validationG2
382: into l_err_count
383: from iby_ext_bank_accounts_v eba
384: , iby_fd_payments_v ibypmts
385: where eba.ext_bank_account_id = ibypmts.external_bank_account_id
386: and ibypmts.completed_pmts_group_id = p_completed_pmts_group_id
387: and ibypmts.external_bank_account_id is not null;
388:

Line 403: FROM iby_fd_payments_v ibypmts,

399:
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)