DBA Data[Home] [Help]

APPS.XTR_FPS1_P dependencies on XTR_MASTER_CURRENCIES_V

Line 339: from XTR_MASTER_CURRENCIES_V s

335: -- AW Bug 1585466
336: -------------------
337: cursor GET_ROUND_FACTOR is
338: select nvl(rounding_factor,2)
339: from XTR_MASTER_CURRENCIES_V s
340: where s.CURRENCY = l_ccy;
341: --
342: cursor BKGE_DETAILS is
343: select b.CALC_BASIS,

Line 384: from XTR_MASTER_CURRENCIES_V s

380: -------------------
381: cursor CALC_HCE_AMTS is
382: select round((l_tax_out / s.hce_rate),nvl(rounding_factor,2)),
383: round((l_bkge_out / s.hce_rate),nvl(rounding_factor,2))
384: from XTR_MASTER_CURRENCIES_V s
385: where s.CURRENCY = l_ccy;
386: --
387: /*
388: cursor Y_BASE is

Line 714: from XTR_MASTER_CURRENCIES_V

710: l_level OUT NOCOPY VARCHAR2) is
711: --
712: cursor CCY is
713: select NAME, YEAR_BASIS, ROUNDING_FACTOR
714: from XTR_MASTER_CURRENCIES_V
715: where CURRENCY = l_currency;
716: -- and AUTHORISED = 'Y';
717: --
718: begin