DBA Data[Home] [Help]

APPS.AP_WEB_OA_MAINFLOW_PKG dependencies on AP_EXPENSE_REPORT_LINES_ALL

Line 820: FROM AP_EXPENSE_REPORT_LINES_ALL

816: SUM(DECODE(SIGN(amount),-1,0,amount))
817: INTO
818: l_neg_pos_total,
819: l_pos_total
820: FROM AP_EXPENSE_REPORT_LINES_ALL
821: WHERE REPORT_HEADER_ID = p_report_header_id
822: AND (itemization_parent_id is null OR itemization_parent_id <> -1);
823: EXCEPTION
824: WHEN OTHERS THEN