APPS.CE_CEXSTMSR_XMLP_PKG dependencies on CE_STATEMENT_LINES

Line 118: ITEMS CE_STATEMENT_LINES.STATEMENT_LINE_ID%TYPE;

114:
115: FUNCTION C_ITEMSFORMULA(C_STAT_HEADER_ID IN NUMBER) RETURN NUMBER IS
116: BEGIN
117: DECLARE
118: ITEMS CE_STATEMENT_LINES.STATEMENT_LINE_ID%TYPE;
119: BEGIN
120: SELECT
121: count(*)
122: INTO

Line 125: CE_STATEMENT_LINES

121: count(*)
122: INTO
123: ITEMS
124: FROM
125: CE_STATEMENT_LINES
126: WHERE STATEMENT_HEADER_ID = C_STAT_HEADER_ID;
127: RETURN (NVL(ITEMS
128: ,0));
129: EXCEPTION

Line 139: ITEMS CE_STATEMENT_LINES.STATEMENT_LINE_ID%TYPE;

135:
136: FUNCTION C_UNREC_ITEMSFORMULA(C_STAT_HEADER_ID IN NUMBER) RETURN NUMBER IS
137: BEGIN
138: DECLARE
139: ITEMS CE_STATEMENT_LINES.STATEMENT_LINE_ID%TYPE;
140: BEGIN
141: SELECT
142: count(*)
143: INTO

Line 146: CE_STATEMENT_LINES

142: count(*)
143: INTO
144: ITEMS
145: FROM
146: CE_STATEMENT_LINES
147: WHERE STATEMENT_HEADER_ID = C_STAT_HEADER_ID
148: AND STATUS = 'UNRECONCILED';
149: RETURN (NVL(ITEMS
150: ,0));

Line 161: AMOUNT CE_STATEMENT_LINES.AMOUNT%TYPE;

157:
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)

Line 169: CE_STATEMENT_LINES

165: SUM(AMOUNT)
166: INTO
167: AMOUNT
168: FROM
169: CE_STATEMENT_LINES
170: WHERE STATEMENT_HEADER_ID = C_STAT_HEADER_ID;
171: SELECT
172: SUM(AMOUNT_CLEARED)
173: INTO