APPS.XTR_EXP_SUMM_P dependencies on XTR_MASTER_CURRENCIES

Line 243: from XTR_MASTER_CURRENCIES

239: TRANSACTION_NUMBER,nvl(EXPOSURE_REF_DATE,AMOUNT_DATE);
240: --
241: cursor HCE is
242: select HCE_RATE
243: from XTR_MASTER_CURRENCIES
244: where CURRENCY = l_ccy;
245: --
246: begin
247: delete from XTR_exposure_summary

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;

Line 1042: from XTR_master_currencies

1038: bal get_ca_row%ROWTYPE;
1039: --
1040: cursor get_hce_rate(l_ccy varchar2) is
1041: select nvl(hce_rate,1),year_basis
1042: from XTR_master_currencies
1043: where currency = l_ccy;
1044: --
1045: l_hce_rate number;
1046: l_year_basis number;

Line 1317: from XTR_master_currencies

1313: l_nxt_date date;
1314: --
1315: cursor get_hce_rate(l_ccy varchar2) is
1316: select nvl(hce_rate,1),year_basis
1317: from XTR_master_currencies
1318: where currency = l_ccy;
1319: --
1320: l_hce_rate number;
1321: l_year_basis number;

Line 1378: from XTR_MASTER_CURRENCIES s

1374: --
1375: cursor HCE is
1376: select round(l_interest / s.HCE_RATE,2),
1377: round(l_gross / s.HCE_RATE,0)
1378: from XTR_MASTER_CURRENCIES s
1379: where s.CURRENCY = L_CURRENCY;
1380: --
1381:
1382: begin