DBA Data[Home] [Help]

APPS.AP_WITHHOLDING_PKG dependencies on IBY_FD_DOCS_PAYABLE_V

Line 3425: iby_fd_docs_payable_v ibydocs

3421: SELECT ASI.invoice_id,
3422: ASI.payment_num,
3423: p_check_date payment_date
3424: FROM ap_selected_invoices_all ASI,
3425: iby_fd_docs_payable_v ibydocs
3426: WHERE ASI.checkrun_name = p_checkrun_name
3427: AND ASI.original_invoice_id IS NULL
3428: and asi.checkrun_id = p_checkrun_id
3429: and ibydocs.calling_app_doc_unique_ref1 = to_char(asi.checkrun_id) /* Added to_char for bug#8462020 */

Line 3564: , iby_fd_docs_payable_v ibydocs

3560: , ASI.payment_num
3561: , AI.vendor_id
3562: FROM ap_SELECTed_invoices_all ASI
3563: , ap_invoices_all AI
3564: , iby_fd_docs_payable_v ibydocs
3565: WHERE ASI.checkrun_name = p_checkrun_name
3566: AND AI.invoice_id = ASI.invoice_id
3567: and asi.checkrun_id = p_checkrun_id
3568: and ibydocs.completed_pmts_group_id = p_completed_pmts_group_id