APPS.CE_CEXSTMSR_XMLP_PKG dependencies on CE_RECONCILED_TRANSACTIONS_V

Line 162: AMOUNT_CLEARED CE_RECONCILED_TRANSACTIONS_V.AMOUNT_CLEARED%TYPE;

158: FUNCTION C_STAT_UNREC_AMOUNTFORMULA(C_STAT_HEADER_ID IN NUMBER) RETURN NUMBER IS
159: BEGIN
160: DECLARE
161: AMOUNT CE_STATEMENT_LINES.AMOUNT%TYPE;
162: AMOUNT_CLEARED CE_RECONCILED_TRANSACTIONS_V.AMOUNT_CLEARED%TYPE;
163: BEGIN
164: SELECT
165: SUM(AMOUNT)
166: INTO

Line 176: CE_RECONCILED_TRANSACTIONS_V

172: SUM(AMOUNT_CLEARED)
173: INTO
174: AMOUNT_CLEARED
175: FROM
176: CE_RECONCILED_TRANSACTIONS_V
177: WHERE STATEMENT_HEADER_ID = C_STAT_HEADER_ID;
178: RETURN (NVL(AMOUNT
179: ,0) - NVL(AMOUNT_CLEARED
180: ,0));