DBA Data[Home] [Help]

APPS.ARP_TRX_VAL dependencies on DUAL

Line 166: from dual

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

Line 185: from dual

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

Line 201: from dual

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

Line 221: from dual

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