DBA Data[Home] [Help]

APPS.HR_SALARY2_WEB dependencies on FND_CURRENCIES_VL

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 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);