[Home] [Help]
1506: --
1507: CURSOR inv_num_cursor IS
1508: SELECT ai.invoice_num
1509: FROM ap_invoices ai,
1510: ap_invoice_payments aip
1511: WHERE aip.check_id = l_check_id
1512: AND aip.invoice_id = ai.invoice_id;
1513:
1514: BEGIN
1644: -- are unposted (N). The status should be partial (P).
1645: --
1646:
1647: -- Fix for 1375672. Modified the cursor to select the posted_flag from
1648: -- ap_invoice_payments and ap_payment_history. Previously, the cursor
1649: -- selected the cash_posted_flag and accrual_posted_flag (depending upon
1650: -- the accounting option) from ap_invoice_payments only, ignoring
1651: -- the ap_payment_history table.
1652:
1646:
1647: -- Fix for 1375672. Modified the cursor to select the posted_flag from
1648: -- ap_invoice_payments and ap_payment_history. Previously, the cursor
1649: -- selected the cash_posted_flag and accrual_posted_flag (depending upon
1650: -- the accounting option) from ap_invoice_payments only, ignoring
1651: -- the ap_payment_history table.
1652:
1653: -- bug 3676049 Posting status of check is irrespective of Payment Maturity
1654: -- when Payment Accounting = 'CLEARING ONLY'
1653: -- bug 3676049 Posting status of check is irrespective of Payment Maturity
1654: -- when Payment Accounting = 'CLEARING ONLY'
1655: CURSOR posting_cursor IS
1656: SELECT posted_flag
1657: FROM ap_invoice_payments_all
1658: WHERE check_id = l_check_id
1659: UNION ALL
1660: SELECT posted_flag
1661: FROM ap_payment_history aph, ap_system_parameters asp