APPS.AP_WEB_AME_PKG dependencies on AP_EXPENSE_REPORT_LINES_ALL

Line 227: FROM AP_EXPENSE_REPORT_LINES_ALL

223: -- If project is enabled, then get the total reimbursable amount for the same project number. Otherwise, if line-level-accounting is enabled, get the total reimbursable amount for the same cost center
224:
225: SELECT SUM(AMOUNT)
226: INTO l_line_item_total
227: FROM AP_EXPENSE_REPORT_LINES_ALL
228: WHERE REPORT_HEADER_ID = p_report_header_id
229: AND FLEX_CONCATENATED = (
230: SELECT FLEX_CONCATENATED
231: FROM AP_EXPENSE_REPORT_LINES_ALL

Line 231: FROM AP_EXPENSE_REPORT_LINES_ALL

227: FROM AP_EXPENSE_REPORT_LINES_ALL
228: WHERE REPORT_HEADER_ID = p_report_header_id
229: AND FLEX_CONCATENATED = (
230: SELECT FLEX_CONCATENATED
231: FROM AP_EXPENSE_REPORT_LINES_ALL
232: WHERE REPORT_HEADER_ID = p_report_header_id
233: AND DISTRIBUTION_LINE_NUMBER = p_line_number
234: )
235: AND itemization_parent_id <> -1;

Line 553: from ap_expense_report_lines_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
553: from ap_expense_report_lines_all
554: where report_header_id = p_report_header_id
555: and distribution_line_number = p_item_id;
556: -- and report_line_id = p_item_id;
557: elsif (p_item_class = C_PROJECT) then

Line 844: from ap_expense_report_lines_all xl

840: -- 5417790: include only itemization child lines in the cursor as we
841: -- display only the child lines in the notification.
842: cursor c1(p_report_header_id in number) is
843: select report_line_id, nvl(amount,0) amount, distribution_line_number, itemization_parent_id
844: from ap_expense_report_lines_all xl
845: where xl.report_header_id = p_report_header_id
846: and (xl.itemization_parent_id is null or xl.itemization_parent_id <> -1);
847:
848: l_debug_info VARCHAR2(200);