DBA Data[Home] [Help]

APPS.AP_WEB_PAYMENTS_PKG dependencies on AP_EXPENSE_REPORT_HEADERS

Line 335: from ap_expense_report_headers

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

Line 346: from ap_expense_report_headers

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

Line 405: FROM ap_expense_report_headers

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