APPS.AP_WEB_AME_PKG dependencies on AP_EXPENSE_REPORT_HEADERS

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 482: from ap_expense_report_headers aerh,

478: l_debug_info := 'Check if in-process Missing Receipts Shortpay';
479: ------------------------------------------------------------
480: select ame_util.booleanAttributeTrue
481: into l_is_missing_shortpay
482: from ap_expense_report_headers aerh,
483: wf_items wf
484: where aerh.report_header_id = p_report_header_id
485: and aerh.shortpay_parent_id is not null
486: and wf.item_type = l_apexp

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