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_TE_EIS_PKG dependencies on AP_INVOICE_PAYMENTS

Line 64: from AP_INVOICE_PAYMENTS p,

60:
61: BEGIN
62: select SUM(P.amount)
63: into P_Result
64: from AP_INVOICE_PAYMENTS p,
65: AP_INVOICES i
66: where p.invoice_id = i.invoice_id
67: and p.set_of_books_id = P_Set_Of_Books_ID
68: and i.invoice_type_lookup_code = 'EXPENSE REPORT'

Line 89: from AP_INVOICE_PAYMENTS p,

85:
86: BEGIN
87: select COUNT(p.invoice_payment_id)
88: into P_Result
89: from AP_INVOICE_PAYMENTS p,
90: AP_INVOICES i
91: where p.invoice_id = i.invoice_id
92: and p.set_of_books_id = P_Set_Of_Books_ID
93: and i.invoice_type_lookup_code = 'EXPENSE REPORT'

Line 112: from AP_INVOICE_PAYMENTS p,

108:
109: BEGIN
110: select AVG(p.amount)
111: into P_Result
112: from AP_INVOICE_PAYMENTS p,
113: AP_INVOICES i
114: where p.invoice_id = i.invoice_id
115: and p.set_of_books_id = P_Set_Of_Books_ID
116: and i.invoice_type_lookup_code = 'EXPENSE REPORT'