APPS.XTR_LIMITS_P dependencies on XTR_MASTER_CURRENCIES_V

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 1830: update xtr_MASTER_CURRENCIES_V

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_V
1831: set UTILISED_AMOUNT = 0;
1832: update xtr_COUNTRY_COMPANY_LIMITS_V
1833: set UTILISED_AMOUNT = 0;
1834: update xtr_GROUP_LIMITS_V