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'
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'
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'