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));