APPS.JL_AR_AP_WITHHOLDING_PKG dependencies on IBY_FD_PAYMENTS_V

Line 1041: from iby_fd_payments_v pmt

1037: l_status Boolean;
1038:
1039: cursor c_spoiled_pmt (p_pmt_instruction_id IN NUMBER) is
1040: select pmt.payment_id
1041: from iby_fd_payments_v pmt
1042: where pmt.payment_instruction_id = p_pmt_instruction_id
1043: and pmt.payment_status ='REMOVED_DOCUMENT_SPOILED' ;
1044:
1045: cursor c_reprint_pmt (p_pmt_instruction_id IN NUMBER) is

Line 1047: from iby_fd_payments_v pmt

1043: and pmt.payment_status ='REMOVED_DOCUMENT_SPOILED' ;
1044:
1045: cursor c_reprint_pmt (p_pmt_instruction_id IN NUMBER) is
1046: select pmt.payment_id
1047: from iby_fd_payments_v pmt
1048: where pmt.payment_instruction_id = p_pmt_instruction_id
1049: and pmt.payment_status ='READY_TO_REPRINT';
1050:
1051:

Line 1793: FROM IBY_FD_PAYMENTS_V ipmt,

1789: docs.calling_app_doc_unique_ref3 payment_num,
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'

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: /*