APPS.JL_AR_AP_WITHHOLDING_PKG dependencies on IBY_FD_DOCS_PAYABLE_V

Line 1794: IBY_FD_DOCS_PAYABLE_V docs

1790: docs.document_currency_code invoice_curr_code,
1791: docs.payment_date,
1792: docs.org_id
1793: FROM IBY_FD_PAYMENTS_V ipmt,
1794: IBY_FD_DOCS_PAYABLE_V docs
1795: WHERE to_number(docs.calling_app_doc_unique_ref1) = p_checkrun_id
1796: AND ipmt.payment_id = docs.payment_id
1797: AND (ipmt.payment_status = 'NEGOTIABLE'
1798: OR ipmt.payment_status = 'ISSUED'

Line 5378: FROM iby_fd_payments_v p,iby_fd_docs_payable_v d

5374: ------------------------------------------------------
5375: CURSOR c_selected_invoice_checks
5376: IS
5377: SELECT distinct(d.payment_id) check_id
5378: FROM iby_fd_payments_v p,iby_fd_docs_payable_v d
5379: WHERE to_number(d.calling_app_doc_unique_ref1) = p_checkrun_id
5380: AND p.payment_id = d.payment_id;
5381:
5382: /*