306: round(p_ra_line.billed_amount/c1.minimum_accountable_unit)
307: * c1.minimum_accountable_unit )
308: into l_rounded_amount
309: from
310: fnd_currencies c1
311: where
312: c1.currency_code = p_ra_line.currency_code;
313:
314: -- get rounded unit price
317: round(p_ra_line.unit_selling_price/c1.minimum_accountable_unit)
318: * c1.minimum_accountable_unit )
319: into l_rounded_unit_price
320: from
321: fnd_currencies c1
322: where
323: c1.currency_code = p_ra_line.currency_code;
324:
325: -- get rounded conversion rate
328: round(nvl(p_ra_line.conversion_rate,1)/c1.minimum_accountable_unit)
329: * c1.minimum_accountable_unit )
330: into l_rounded_conv_rate
331: from
332: fnd_currencies c1
333: where
334: c1.currency_code = p_ra_line.currency_code;
335:
336: l_stmt := 45;
579: round(p_wob_rec.billed_amount/c1.minimum_accountable_unit)
580: * c1.minimum_accountable_unit )
581: into l_rounded_amount
582: from
583: fnd_currencies c1
584: where
585: c1.currency_code = p_wob_rec.currency_code;
586:
587: -- get rounded cost_or_list_price
590: round(p_wob_rec.cost_or_listprice/c1.minimum_accountable_unit)
591: * c1.minimum_accountable_unit )
592: into l_rounded_unit_price
593: from
594: fnd_currencies c1
595: where
596: c1.currency_code = p_wob_rec.currency_code;
597:
598: -- get rounded conversion rate
601: round(p_wob_rec.conversion_rate/c1.minimum_accountable_unit)
602: * c1.minimum_accountable_unit )
603: into l_rounded_conv_rate
604: from
605: fnd_currencies c1
606: where
607: c1.currency_code = p_wob_rec.currency_code;
608:
609:
850: round(p_pa_rec.bill_trans_bill_amount/c1.minimum_accountable_unit)
851: * c1.minimum_accountable_unit )
852: into l_rounded_amount
853: from
854: fnd_currencies c1
855: where
856: c1.currency_code = p_pa_rec.billing_currency_code;
857:
858: