DBA Data[Home] [Help]

APPS.EAM_WORKORDERBILLING_PVT dependencies on FND_CURRENCIES

Line 197: fnd_currencies c1

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

Line 208: fnd_currencies c1

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

Line 219: fnd_currencies c1

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;

Line 459: fnd_currencies c1

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

Line 470: fnd_currencies c1

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

Line 481: fnd_currencies c1

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:

Line 730: fnd_currencies c1

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: