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 554: from ap_expense_report_headers_all

550:
551: if (p_item_class = C_HEADER) then
552: select total
553: into p_amount
554: from ap_expense_report_headers_all
555: where report_header_id = p_report_header_id;
556: elsif (p_item_class = C_LINE_ITEM) then
557: select sum(amount)
558: into p_amount