APPS.HR_SALARY2_WEB dependencies on FND_CURRENCIES

Line 45: FROM FND_CURRENCIES_VL CUR

41: p_date DATE ) RETURN VARCHAR2
42: IS
43: CURSOR lc_currency_symbol IS
44: SELECT CUR.SYMBOL
45: FROM FND_CURRENCIES_VL CUR
46: WHERE CUR.CURRENCY_CODE=p_currency_code
47: AND p_date BETWEEN
48: NVL(CUR.START_DATE_ACTIVE,p_date) AND
49: NVL(CUR.END_DATE_ACTIVE,p_date+1);

Line 51: lv_symbol fnd_currencies.symbol%type;

47: AND p_date BETWEEN
48: NVL(CUR.START_DATE_ACTIVE,p_date) AND
49: NVL(CUR.END_DATE_ACTIVE,p_date+1);
50:
51: lv_symbol fnd_currencies.symbol%type;
52:
53: BEGIN
54: OPEN lc_currency_symbol ;
55: FETCH lc_currency_symbol into lv_symbol ;

Line 109: FROM FND_CURRENCIES_VL CUR

105: p_date DATE ) RETURN NUMBER
106: IS
107: CURSOR c_precision IS
108: SELECT CUR.PRECISION
109: FROM FND_CURRENCIES_VL CUR
110: WHERE CUR.CURRENCY_CODE=p_currency_code
111: AND p_date BETWEEN
112: NVL(CUR.START_DATE_ACTIVE,p_date) AND
113: NVL(CUR.END_DATE_ACTIVE,p_date+1);