APPS.JL_AR_AP_WITHHOLDING_PKG dependencies on IBY_FD_DOCS_PAYABLE_V

Line 1867: IBY_FD_DOCS_PAYABLE_V docs

1863: docs.document_currency_code invoice_curr_code,
1864: docs.payment_date,
1865: docs.org_id
1866: FROM IBY_FD_PAYMENTS_V ipmt,
1867: IBY_FD_DOCS_PAYABLE_V docs
1868: WHERE to_number(docs.calling_app_doc_unique_ref1) = p_checkrun_id
1869: AND ipmt.payment_id = docs.payment_id
1870: AND (ipmt.payment_status = 'NEGOTIABLE'
1871: OR ipmt.payment_status = 'ISSUED'

Line 5675: FROM iby_fd_payments_v p,iby_fd_docs_payable_v d

5671: ------------------------------------------------------
5672: CURSOR c_selected_invoice_checks
5673: IS
5674: SELECT distinct(d.payment_id) check_id
5675: FROM iby_fd_payments_v p,iby_fd_docs_payable_v d
5676: WHERE d.calling_app_doc_unique_ref1 = to_char(p_checkrun_id) --bug9836895
5677: AND p.payment_id = d.payment_id
5678: AND d.calling_app_id = 200; --bug9836895
5679: