APPS.GMF_GL_GET_CONVERSION_TYPES SQL Statements

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

Line: 6

          SELECT  conversion_type,
                user_conversion_type,
                description,
                creation_date,
                last_update_date,
                created_by,
                last_updated_by
          FROM  GL_DAILY_CONVERSION_TYPES
          WHERE  nvl(user_conversion_type,' ')  like
                  nvl(usr_conversiontype,nvl(user_conversion_type,' '))
                                      AND
      /*        nvl(description,' ')  like
                      nvl(descr,nvl(description,' '))   AND
                      */
              last_update_date  BETWEEN
              nvl(startdate,last_update_date)  AND
              nvl(enddate,last_update_date);

Line: 26

                              last_update_date out NOCOPY date,
                              created_by out NOCOPY number,
                              last_updated_by out NOCOPY number,
                              conversiontype in out NOCOPY varchar2,
                              usr_conversiontype in out NOCOPY varchar2,
                              descr in out NOCOPY varchar2,
                              row_to_fetch in out NOCOPY number,
                              statuscode out NOCOPY number) IS
      BEGIN
        IF NOT conversion_types%ISOPEN THEN
          OPEN conversion_types(startdate,enddate,usr_conversiontype);

Line: 42

                            last_update_date,
                            created_by,
                            last_updated_by ;