DBA Data[Home] [Help]

APPS.XTR_STOCK_PKG dependencies on XTR_MASTER_CURRENCIES_V

Line 36: from XTR_MASTER_CURRENCIES_V

32: or(PARTY_TYPE = 'C' and substr(BANK_SHORT_CODE, 1, 7) = D.CPARTY_REF));
33:
34: cursor HCE_RATE(p_currency VARCHAR2) is
35: select rounding_factor, hce_rate
36: from XTR_MASTER_CURRENCIES_V
37: where currency = p_currency;
38:
39: l_div_id NUMBER;
40: l_div NUMBER;

Line 261: from XTR_MASTER_CURRENCIES_V

257: and start_date >= p_sell_date;
258:
259: cursor cur_hce is
260: select rounding_factor, hce_rate
261: from XTR_MASTER_CURRENCIES_V
262: where currency = p_currency;
263:
264: l_rowid VARCHAR2(30);
265: l_tax_ref NUMBER;

Line 713: from XTR_MASTER_CURRENCIES_V

709: -- Get rounding currency and hce_rate
710: --------------------------------------------
711: cursor ROUND_FACTOR is
712: select rounding_factor, hce_rate
713: from XTR_MASTER_CURRENCIES_V
714: where currency = p_currency;
715:
716: --------------------------------------------
717: -- Get home rounding curency

Line 721: from XTR_MASTER_CURRENCIES_V a,

717: -- Get home rounding curency
718: --------------------------------------------
719: cursor HCE_ROUND_FACTOR is
720: select a.rounding_factor
721: from XTR_MASTER_CURRENCIES_V a,
722: XTR_PRO_PARAM b
723: where b.param_name = 'SYSTEM_FUNCTIONAL_CCY'
724: and a.currency = param_value;
725: