162: CURSOR invalid_amounts IS
163: /* Currency references line amounts with invalid precision */
164: select 1,
165: 'AR_TW_BAD_CURR_LINE_AMT'
166: from dual
167: where rownum = 1
168: and exists
169: (select 'invalid precision'
170: from ra_customer_trx_lines line
181: UNION ALL
182: /* Currency references distribution amounts with invalid precision */
183: select 2,
184: 'AR_TW_BAD_CURR_DIST_AMT'
185: from dual
186: where rownum = 1
187: and exists
188: (select 'invalid precision'
189: from ra_cust_trx_line_gl_dist
197: UNION ALL
198: /* Currency references salesrep amounts with invalid precision */
199: select 3,
200: 'AR_TW_BAD_CURR_SREP_AMT'
201: from dual
202: where rownum = 1
203: and exists
204: (select 'invalid precision'
205: from ra_cust_trx_line_salesreps
217: UNION ALL
218: /* Currency references installment amounts with invalid precision */
219: select 4,
220: 'AR_TW_BAD_CURR_PS_AMT'
221: from dual
222: where rownum = 1
223: and exists
224: (select 'invalid precision'
225: from ar_payment_schedules