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.JAI_ST_REVERSAL_EXTRACT_PKG dependencies on AP_CHECKS_ALL

Line 338: ap_checks_all aca

334:
335: CURSOR c_max_payment_date(cp_invoice_id NUMBER) IS
336: SELECT MAX(aca.check_date)
337: FROM ap_invoice_payments_all aipa,
338: ap_checks_all aca
339: WHERE aipa.invoice_id = cp_invoice_id
340: AND aca.check_id = aipa.check_id;
341:
342: CURSOR c_max_prepayment_date (cp_invoice_id NUMBER) IS

Line 429: FROM ap_checks_all apc

425: AND aida.accounting_date <= cd_as_of_date;
426:
427: CURSOR c_paid_amt(cp_invoice_id NUMBER, cp_grace_date DATE) IS
428: SELECT nvl(SUM(apc.amount),0)
429: FROM ap_checks_all apc
430: , ap_invoice_payments_all apip
431: WHERE apc.check_id = apip.check_id
432: AND apip.invoice_id = cp_invoice_id
433: AND apc.check_date <= cp_grace_date;