APPS.PO_CURRENCY_SV SQL Statements

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

Line: 25

  SELECT  currency_code
  INTO    X_currency_code_v
  FROM    fnd_currencies
  WHERE   enabled_flag = 'Y'
  AND	  sysdate between nvl(start_date_active, sysdate - 1)
  AND	  nvl(end_date_active, sysdate + 1)
  AND	  currency_code = X_currency_code;

Line: 181

   SELECT dct.user_conversion_type
   INTO   x_rate_type_disp
   FROM   gl_daily_conversion_types  dct
   WHERE  dct.conversion_type = x_rate_type;

Line: 208

 cursor C is SELECT start_date_active, end_date_active,
                   enabled_flag
             FROM fnd_currencies
             WHERE fnd_currencies.currency_code = p_cur_record.currency_code;

Line: 296

       SELECT sob.currency_code
       INTO  x_functional_currency_code
       FROM  gl_sets_of_books sob, financials_system_params_all fsp
       WHERE nvl(fsp.org_id, -99) = nvl(p_org_id, -99)
       AND  fsp.set_of_books_id = sob.set_of_books_id;

Line: 556

  select default_rate_type
  into  l_rate_type
  from  po_system_parameters_all psp
  where nvl(psp.org_id, -99) = nvl(p_to_ou_id, -99);