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

472: l_debug_info := 'Check if in-process Missing Receipts Shortpay';
473: ------------------------------------------------------------
474: select ame_util.booleanAttributeTrue
475: into l_is_missing_shortpay
476: from ap_expense_report_headers aerh,
477: wf_items wf
478: where aerh.report_header_id = p_report_header_id
479: and aerh.shortpay_parent_id is not null
480: and wf.item_type = l_apexp

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