APPS.GMF_GL_GET_CURRENCIES SQL Statements

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

Line: 5

        SELECT   currency_code, name, description, precision, symbol,
               creation_date, created_by,
		last_update_date,last_updated_by
             FROM  fnd_currencies_vl
        WHERE    currency_code like cur_code AND
               last_update_date BETWEEN nvl(st_date, last_update_date)
               AND nvl(en_date, last_update_date);

Line: 15

          select user_name into usr_name from fnd_user where
          user_id=usr_id;

Line: 29

          last_update_date out  date,
          last_updated_by  out  number,
          row_to_fetch   in out  number,
          error_status out   number) IS
/*   ad_by number;*/

Line: 40

    		INTO   cur_code ,cur_name, descr, preci, symb, 			creation_date,created_by,last_update_date,
			last_updated_by;

Line: 50

/* and last_updated_by.*/
      /*created_by:=get_name(ad_by);*/