DBA Data[Home] [Help]

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: --