APPS.XTR_LIMITS_P dependencies on XTR_MASTER_CURRENCIES

Line 59: from XTR_MASTER_CURRENCIES_V s

55: --
56: --
57: cursor HC_RATE (pc2_amount number, pc2_currency VARCHAR2) is
58: select round((pc2_amount / nvl(s.HCE_RATE ,1)),nvl(s.ROUNDING_FACTOR,2))
59: from XTR_MASTER_CURRENCIES_V s
60: where s.currency = pc2_currency;
61: --
62: v_home_currency VARCHAR2(15);
63: v_hce_utilised_amt NUMBER;

Line 80: from XTR_MASTER_CURRENCIES_V s

76: -- Calculate home-currency-equivalent for p_amount_to_convert
77: --
78: cursor HC_RATE (pc2_amount number, pc2_currency VARCHAR2) is
79: select round((pc2_amount / nvl(s.HCE_RATE ,1)),nvl(s.ROUNDING_FACTOR,2))
80: from XTR_MASTER_CURRENCIES_V s
81: where s.currency = pc2_currency;
82: --
83: v_hce_utilised_amt NUMBER;
84: --

Line 1544: XTR_MASTER_CURRENCIES M

1540: select nvl(max(B.LIMIT_AMOUNT),0) LIMIT_AMT,
1541: nvl(sum(round(abs(A.CASHFLOW_AMOUNT) / M.HCE_RATE,0)),0) UTILISED
1542: from XTR_DEAL_DATE_AMOUNTS A,
1543: XTR_COUNTERPARTY_LIMITS B,
1544: XTR_MASTER_CURRENCIES M
1545: where A.ACTUAL_SETTLEMENT_DATE = pc1_amount_date
1546: and A.SETTLE = 'Y'
1547: and A.COMPANY_CODE = pc1_company_code
1548: and A.AMOUNT_TYPE NOT IN ('FXOBUY','FXOSELL')

Line 1639: xtr_master_currencies mc

1635: SELECT nvl(max(cl.limit_amount),0),
1636: nvl(sum(round(abs(s.cashflow_amount)/mc.hce_rate,0)),0)
1637: FROM xtr_settlements_v s,
1638: xtr_counterparty_limits cl,
1639: xtr_master_currencies mc
1640: WHERE s.amount_date > trunc(sysdate)
1641: AND cl.cparty_code = s.cparty
1642: AND cl.company_code = s.company
1643: AND cl.limit_code = 'SETTLE'

Line 1664: FROM XTR_SETTLEMENTS_V a, XTR_MASTER_CURRENCIES m

1660: SELECT nvl(SUM(ROUND(ABS(a.CASHFLOW_AMOUNT) / m.HCE_RATE,0)),0) UTILISED_AMOUNT,
1661: a.CPARTY CPARTY_CODE,
1662: a.COMPANY COMPANY_CODE,
1663: nvl(a.AMOUNT_DATE,TRUNC(SYSDATE)) EFFECTIVE_DATE
1664: FROM XTR_SETTLEMENTS_V a, XTR_MASTER_CURRENCIES m
1665: WHERE a.AMOUNT_DATE = trunc(SYSDATE)
1666: AND a.CASHFLOW_AMOUNT <> 0
1667: AND m.CURRENCY = a.CURRENCY
1668: AND (

Line 1758: FROM xtr_master_currencies mc

1754: p_err_code OUT NOCOPY VARCHAR2) is
1755: --
1756: cursor c_get_util(pc1_currency VARCHAR2) is
1757: SELECT nvl(mc.net_fx_exposure,0), nvl(mc.utilised_amount,0)
1758: FROM xtr_master_currencies mc
1759: WHERE mc.authorised = 'Y'
1760: AND (mc.net_fx_exposure <> 0 OR mc.utilised_amount <> 0)
1761: /* bug 1289530 limit check should be done for home ccy
1762: AND mc.currency <> (SELECT max(param_value)

Line 1830: update xtr_MASTER_CURRENCIES

1826: update xtr_COMPANY_LIMITS_V
1827: set UTILISED_AMOUNT = 0;
1828: update xtr_COUNTERPARTY_LIMITS_V
1829: set UTILISED_AMOUNT = 0;
1830: update xtr_MASTER_CURRENCIES
1831: set UTILISED_AMOUNT = 0;
1832: update xtr_COUNTRY_COMPANY_LIMITS_V
1833: set UTILISED_AMOUNT = 0;
1834: update xtr_GROUP_LIMITS_V