eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_CHECKS_PKG dependencies on AP_INVOICE_PAYMENTS

Line 1392: ap_invoice_payments aip

1388: --
1389: CURSOR inv_num_cursor IS
1390: SELECT ai.invoice_num
1391: FROM ap_invoices ai,
1392: ap_invoice_payments aip
1393: WHERE aip.check_id = l_check_id
1394: AND aip.invoice_id = ai.invoice_id;
1395:
1396: BEGIN

Line 1530: -- ap_invoice_payments and ap_payment_history. Previously, the cursor

1526: -- are unposted (N). The status should be partial (P).
1527: --
1528:
1529: -- Fix for 1375672. Modified the cursor to select the posted_flag from
1530: -- ap_invoice_payments and ap_payment_history. Previously, the cursor
1531: -- selected the cash_posted_flag and accrual_posted_flag (depending upon
1532: -- the accounting option) from ap_invoice_payments only, ignoring
1533: -- the ap_payment_history table.
1534:

Line 1532: -- the accounting option) from ap_invoice_payments only, ignoring

1528:
1529: -- Fix for 1375672. Modified the cursor to select the posted_flag from
1530: -- ap_invoice_payments and ap_payment_history. Previously, the cursor
1531: -- selected the cash_posted_flag and accrual_posted_flag (depending upon
1532: -- the accounting option) from ap_invoice_payments only, ignoring
1533: -- the ap_payment_history table.
1534:
1535: -- bug 3676049 Posting status of check is irrespective of Payment Maturity
1536: -- when Payment Accounting = 'CLEARING ONLY'

Line 1539: FROM ap_invoice_payments_all

1535: -- bug 3676049 Posting status of check is irrespective of Payment Maturity
1536: -- when Payment Accounting = 'CLEARING ONLY'
1537: CURSOR posting_cursor IS
1538: SELECT posted_flag
1539: FROM ap_invoice_payments_all
1540: WHERE check_id = l_check_id
1541: UNION ALL
1542: SELECT posted_flag
1543: FROM ap_payment_history aph, ap_system_parameters asp