APPS.XTR_EXP_SUMM_P dependencies on XTR_MASTER_CURRENCIES_V

Line 350: from XTR_MASTER_CURRENCIES_V m1,

346: round(decode(m1.divide_or_multiply,'*',1 / l_ccya_spot,l_ccya_spot),9),
347: decode(m1.divide_or_multiply,'*','BASE','CONTRA'),
348: round(decode(m2.divide_or_multiply,'*',1 / l_ccyb_spot,l_ccyb_spot),9),
349: decode(m2.divide_or_multiply,'*','BASE','CONTRA')
350: from XTR_MASTER_CURRENCIES_V m1,
351: XTR_MASTER_CURRENCIES_V m2,
352: XTR_MASTER_CURRENCIES_V m3
353: where m1.CURRENCY = l_ccya
354: and m2.CURRENCY = l_ccyb

Line 351: XTR_MASTER_CURRENCIES_V m2,

347: decode(m1.divide_or_multiply,'*','BASE','CONTRA'),
348: round(decode(m2.divide_or_multiply,'*',1 / l_ccyb_spot,l_ccyb_spot),9),
349: decode(m2.divide_or_multiply,'*','BASE','CONTRA')
350: from XTR_MASTER_CURRENCIES_V m1,
351: XTR_MASTER_CURRENCIES_V m2,
352: XTR_MASTER_CURRENCIES_V m3
353: where m1.CURRENCY = l_ccya
354: and m2.CURRENCY = l_ccyb
355: and m3.CURRENCY = 'USD';

Line 352: XTR_MASTER_CURRENCIES_V m3

348: round(decode(m2.divide_or_multiply,'*',1 / l_ccyb_spot,l_ccyb_spot),9),
349: decode(m2.divide_or_multiply,'*','BASE','CONTRA')
350: from XTR_MASTER_CURRENCIES_V m1,
351: XTR_MASTER_CURRENCIES_V m2,
352: XTR_MASTER_CURRENCIES_V m3
353: where m1.CURRENCY = l_ccya
354: and m2.CURRENCY = l_ccyb
355: and m3.CURRENCY = 'USD';
356: --

Line 598: from XTR_MASTER_CURRENCIES_V

594: l_fx_amt NUMBER;
595: --
596: cursor get_ccy_exp is
597: select YEAR_BASIS, ROUNDING_FACTOR
598: from XTR_MASTER_CURRENCIES_V
599: where CURRENCY = l_ccy;
600: --
601: cursor get_ccy_fx is
602: select YEAR_BASIS, ROUNDING_FACTOR

Line 603: from XTR_MASTER_CURRENCIES_V

599: where CURRENCY = l_ccy;
600: --
601: cursor get_ccy_fx is
602: select YEAR_BASIS, ROUNDING_FACTOR
603: from XTR_MASTER_CURRENCIES_V
604: where CURRENCY = l_row_ccy;
605: --
606: l_year_basis NUMBER;
607: l_rounding NUMBER;