APPS.CE_CEXSTMRR_XMLP_PKG dependencies on CE_STATEMENT_LINES

Line 110: AMOUNT CE_STATEMENT_LINES.AMOUNT%TYPE;

106:
107: FUNCTION C_STAT_SUM_LINE_AMOUNTFORMULA(C_STAT_HEADER_ID1 IN NUMBER) RETURN NUMBER IS
108: BEGIN
109: DECLARE
110: AMOUNT CE_STATEMENT_LINES.AMOUNT%TYPE;
111: BEGIN
112: SELECT
113: SUM(SL.AMOUNT)
114: INTO

Line 117: CE_STATEMENT_LINES SL

113: SUM(SL.AMOUNT)
114: INTO
115: AMOUNT
116: FROM
117: CE_STATEMENT_LINES SL
118: WHERE SL.STATEMENT_HEADER_ID = C_STAT_HEADER_ID1
119: AND exists (
120: SELECT
121: DISTINCT

Line 138: AMOUNT CE_STATEMENT_LINES.AMOUNT%TYPE;

134:
135: FUNCTION C_STAT_CR_ERRORSFORMULA(C_STAT_HEADER_ID1 IN NUMBER) RETURN NUMBER IS
136: BEGIN
137: DECLARE
138: AMOUNT CE_STATEMENT_LINES.AMOUNT%TYPE;
139: BEGIN
140: SELECT
141: SUM(SL.AMOUNT)
142: INTO

Line 145: CE_STATEMENT_LINES SL

141: SUM(SL.AMOUNT)
142: INTO
143: AMOUNT
144: FROM
145: CE_STATEMENT_LINES SL
146: WHERE SL.STATEMENT_HEADER_ID = C_STAT_HEADER_ID1
147: AND SL.STATUS = 'ERROR'
148: AND ( SL.TRX_TYPE = 'CREDIT'
149: OR SL.TRX_TYPE = 'MISC_CREDIT'

Line 163: AMOUNT CE_STATEMENT_LINES.AMOUNT%TYPE;

159:
160: FUNCTION C_STAT_DR_ERRORSFORMULA(C_STAT_HEADER_ID1 IN NUMBER) RETURN NUMBER IS
161: BEGIN
162: DECLARE
163: AMOUNT CE_STATEMENT_LINES.AMOUNT%TYPE;
164: BEGIN
165: SELECT
166: SUM(SL.AMOUNT)
167: INTO

Line 170: CE_STATEMENT_LINES SL

166: SUM(SL.AMOUNT)
167: INTO
168: AMOUNT
169: FROM
170: CE_STATEMENT_LINES SL
171: WHERE SL.STATEMENT_HEADER_ID = C_STAT_HEADER_ID1
172: AND SL.STATUS = 'ERROR'
173: AND SL.TRX_TYPE in ( 'DEBIT' , 'MISC_DEBIT' , 'NSF' , 'REJECTED' , 'SWEEP_OUT' );
174: RETURN (NVL(AMOUNT