DBA Data[Home] [Help]

APPS.EAM_WORKORDERBILLING_PVT dependencies on FND_CURRENCIES

Line 310: fnd_currencies c1

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

Line 321: fnd_currencies c1

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

Line 332: fnd_currencies c1

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;

Line 583: fnd_currencies c1

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

Line 594: fnd_currencies c1

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

Line 605: fnd_currencies c1

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:

Line 854: fnd_currencies c1

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: