APPS.XTR_FX_TRANSFERS_PKG dependencies on XTR_MASTER_CURRENCIES_V

Line 731: from xtr_master_currencies_v

727: BEGIN
728: BEGIN
729: Select 'Y'
730: Into l_temp
731: from xtr_master_currencies_v
732: where nvl(authorised,'N') = 'Y'
733: And currency = p_currency
734: and rownum = 1;
735:

Line 1273: from xtr_master_currencies_v m

1269: roundfac number(3,2);
1270:
1271: cursor rnd(p_curr in VARCHAR2) is
1272: select m.rounding_factor
1273: from xtr_master_currencies_v m
1274: where m.currency = p_curr;
1275:
1276:
1277: begin

Line 1362: xtr_master_currencies_v m

1358: cursor rnd_fac is
1359: select p.home_currency,
1360: m.rounding_factor
1361: from xtr_parties_v p,
1362: xtr_master_currencies_v m
1363: where p.party_code = G_Fx_Main_Rec.company_code
1364: and p.party_type = 'C'
1365: and m.currency = p.home_currency;
1366:

Line 1369: from xtr_master_currencies_v s

1365: and m.currency = p.home_currency;
1366:
1367: cursor hc_rate is
1368: select round((G_Fx_Main_Rec.buy_amount/ s.hce_rate ),roundfac)
1369: from xtr_master_currencies_v s
1370: where s.currency = G_Fx_Main_Rec.currency_buy;
1371:
1372: cursor calc_hce is
1373: select round(((G_Fx_Main_Rec.buy_amount / G_Fx_Main_Rec.base_rate -

Line 1377: from xtr_master_currencies_v s

1373: select round(((G_Fx_Main_Rec.buy_amount / G_Fx_Main_Rec.base_rate -
1374: G_Fx_Main_Rec.sell_amount )/ s.hce_rate),roundfac),
1375: round(((G_Fx_Main_Rec.buy_amount * G_Fx_Main_Rec.base_rate -
1376: G_Fx_Main_Rec.sell_amount )/ s.hce_rate),roundfac)
1377: from xtr_master_currencies_v s
1378: where s.currency = G_Fx_Main_Rec.currency_sell ;
1379:
1380: BEGIN
1381:

Line 1586: from xtr_master_currencies_v m

1582:
1583: /*
1584: cursor rnd is
1585: select m.rounding_factor
1586: from xtr_master_currencies_v m
1587: where m.currency = G_Fx_Main_Rec.currency_sell;
1588: */
1589:
1590: --RV 2342574

Line 1593: from xtr_master_currencies_v m

1589:
1590: --RV 2342574
1591: cursor rnd(p_curr in VARCHAR2) is
1592: select m.rounding_factor
1593: from xtr_master_currencies_v m
1594: where m.currency = p_curr;
1595:
1596: Cursor tol is
1597: select parameter_value