DBA Data[Home] [Help]

APPS.ARP_TRX_VAL dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 75: FROM ra_cust_trx_line_gl_dist

71: IF ( p_commitment_amount IS NULL )
72: THEN
73: SELECT amount
74: INTO l_commitment_amount
75: FROM ra_cust_trx_line_gl_dist
76: WHERE customer_trx_id = p_commitment_trx_id
77: AND latest_rec_flag = 'Y'
78: AND account_class = 'REC';
79: ELSE

Line 189: from ra_cust_trx_line_gl_dist

185: from dual
186: where rownum = 1
187: and exists
188: (select 'invalid precision'
189: from ra_cust_trx_line_gl_dist
190: where ( decode(l_min_acct_unit, null,
191: round(amount, l_precision),
192: round(amount / l_min_acct_unit)
193: * l_min_acct_unit) - amount <> 0 )