331: IF(P_header_id IS NULL) THEN
332:
333: select nvl(sum(maximum_amount_to_apply),0)
334: INTO l_prepay_amt_expensed
335: from ap_expense_report_headers
336: where employee_id = p_employee_id
337: and vouchno = 0
338: and default_currency_code = p_currency
339: AND prepay_num = p_Invoice_num
342: ELSE
343:
344: select nvl(sum(maximum_amount_to_apply),0)
345: INTO l_prepay_amt_expensed
346: from ap_expense_report_headers
347: where employee_id = p_employee_id
348: and vouchno = 0
349: and default_currency_code = p_currency
350: AND prepay_num = p_Invoice_num
401: BEGIN
402:
403: SELECT NVL(SUM(maximum_amount_to_apply),0)
404: INTO l_prepay_amt_expensed
405: FROM ap_expense_report_headers
406: WHERE employee_id = p_employee_id
407: AND vouchno = 0
408: AND default_currency_code = p_currency
409: AND prepay_num = p_Invoice_num