APPS.JL_AR_AP_WITHHOLDING_PKG dependencies on IBY_FD_PAYMENTS_V

Line 1070: from iby_fd_payments_v pmt

1066: l_status Boolean := TRUE; --bug 8680654
1067:
1068: cursor c_spoiled_pmt (p_pmt_instruction_id IN NUMBER) is
1069: select pmt.payment_id
1070: from iby_fd_payments_v pmt
1071: where pmt.payment_instruction_id = p_pmt_instruction_id
1072: and pmt.payment_status ='REMOVED_DOCUMENT_SPOILED' ;
1073:
1074: cursor c_reprint_pmt (p_pmt_instruction_id IN NUMBER) is

Line 1076: from iby_fd_payments_v pmt

1072: and pmt.payment_status ='REMOVED_DOCUMENT_SPOILED' ;
1073:
1074: cursor c_reprint_pmt (p_pmt_instruction_id IN NUMBER) is
1075: select pmt.payment_id
1076: from iby_fd_payments_v pmt
1077: where pmt.payment_instruction_id = p_pmt_instruction_id
1078: and pmt.payment_status ='READY_TO_REPRINT';
1079:
1080: --Bug10012521

Line 1083: from iby_fd_payments_v pmt

1079:
1080: --Bug10012521
1081: cursor c_terminate_pmt (p_pmt_instruction_id IN NUMBER) is
1082: select pmt.payment_id
1083: from iby_fd_payments_v pmt
1084: where pmt.payment_instruction_id = p_pmt_instruction_id ;
1085:
1086:
1087:

Line 1866: FROM IBY_FD_PAYMENTS_V ipmt,

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

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: