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 313: AP_EXPENSE_REPORT_LINES_ALL LINES

309: HR_ORGANIZATION_INFORMATION HOIP,
310: HR_ORGANIZATION_INFORMATION HOIC,
311: HR_ORGANIZATION_INFORMATION HOI,
312: PER_WORKFORCE_CURRENT_X PP,
313: AP_EXPENSE_REPORT_LINES_ALL LINES
314: WHERE ENABLED_FLAG = ''Y''
315: AND GLCC.' || l_segment_name || ' = :costCenter
316: AND LINES.REPORT_HEADER_ID = :reportHeaderId
317: AND CHART_OF_ACCOUNTS_ID = :charOfAccountsId

Line 559: from ap_expense_report_lines_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
559: from ap_expense_report_lines_all
560: where report_header_id = p_report_header_id
561: and distribution_line_number = p_item_id;
562: -- and report_line_id = p_item_id;
563: elsif (p_item_class = C_PROJECT) then

Line 850: from ap_expense_report_lines_all xl

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

Line 896: from ap_expense_report_lines_all

892: oie_ame_notif_gt gt
893: where xd.report_header_id = p_report_header_id
894: and xd.report_line_id in (
895: select report_line_id
896: from ap_expense_report_lines_all
897: where report_header_id = p_report_header_id
898: and itemization_parent_id = i.report_line_id)
899: and ( (xd.cost_center = gt.item_id
900: and