193: round(p_ra_line.billed_amount/c1.minimum_accountable_unit)
194: * c1.minimum_accountable_unit )
195: into l_rounded_amount
196: from
197: fnd_currencies c1
198: where
199: c1.currency_code = p_ra_line.currency_code;
200:
201: -- get rounded unit price
204: round(p_ra_line.unit_selling_price/c1.minimum_accountable_unit)
205: * c1.minimum_accountable_unit )
206: into l_rounded_unit_price
207: from
208: fnd_currencies c1
209: where
210: c1.currency_code = p_ra_line.currency_code;
211:
212: -- get rounded conversion rate
215: round(nvl(p_ra_line.conversion_rate,1)/c1.minimum_accountable_unit)
216: * c1.minimum_accountable_unit )
217: into l_rounded_conv_rate
218: from
219: fnd_currencies c1
220: where
221: c1.currency_code = p_ra_line.currency_code;
222:
223: l_stmt := 45;
455: round(p_wob_rec.billed_amount/c1.minimum_accountable_unit)
456: * c1.minimum_accountable_unit )
457: into l_rounded_amount
458: from
459: fnd_currencies c1
460: where
461: c1.currency_code = p_wob_rec.currency_code;
462:
463: -- get rounded cost_or_list_price
466: round(p_wob_rec.cost_or_listprice/c1.minimum_accountable_unit)
467: * c1.minimum_accountable_unit )
468: into l_rounded_unit_price
469: from
470: fnd_currencies c1
471: where
472: c1.currency_code = p_wob_rec.currency_code;
473:
474: -- get rounded conversion rate
477: round(p_wob_rec.conversion_rate/c1.minimum_accountable_unit)
478: * c1.minimum_accountable_unit )
479: into l_rounded_conv_rate
480: from
481: fnd_currencies c1
482: where
483: c1.currency_code = p_wob_rec.currency_code;
484:
485:
726: round(p_pa_rec.bill_trans_bill_amount/c1.minimum_accountable_unit)
727: * c1.minimum_accountable_unit )
728: into l_rounded_amount
729: from
730: fnd_currencies c1
731: where
732: c1.currency_code = p_pa_rec.billing_currency_code;
733:
734: