DBA Data[Home] [Help]

APPS.AP_WEB_AME_PKG dependencies on AP_EXPENSE_REPORT_HEADERS_ALL

Line 292: ap_expense_report_headers_all erh

288: SELECT GS.chart_of_accounts_id
289: INTO l_char_of_accounts_id
290: FROM ap_system_parameters_all S,
291: gl_sets_of_books GS,
292: ap_expense_report_headers_all erh
293: WHERE GS.set_of_books_id = S.set_of_books_id
294: AND S.org_id = erh.org_id
295: AND erh.report_header_id = p_report_header_id;
296:

Line 548: from ap_expense_report_headers_all

544:
545: if (p_item_class = C_HEADER) then
546: select total
547: into p_amount
548: from ap_expense_report_headers_all
549: where report_header_id = p_report_header_id;
550: elsif (p_item_class = C_LINE_ITEM) then
551: select sum(amount)
552: into p_amount