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