APPS.HR_SALARY2_WEB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 44

     SELECT CUR.SYMBOL
     FROM FND_CURRENCIES_VL CUR
     WHERE CUR.CURRENCY_CODE=p_currency_code
     AND p_date BETWEEN
      NVL(CUR.START_DATE_ACTIVE,p_date) AND
      NVL(CUR.END_DATE_ACTIVE,p_date+1);

Line: 108

     SELECT CUR.PRECISION
     FROM FND_CURRENCIES_VL CUR
     WHERE CUR.CURRENCY_CODE=p_currency_code
     AND p_date BETWEEN
      NVL(CUR.START_DATE_ACTIVE,p_date) AND
      NVL(CUR.END_DATE_ACTIVE,p_date+1);