DBA Data[Home] [Help]

APPS.FAFLEX_PKG_WF SQL Statements

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

Line: 178

      select to_char(nvl(X_Validation_Date,sysdate),'YYYY/MM/DD HH24:MI:SS')
        into char_date
        from dual;
Line: 235

      SELECT book_class
        INTO h_book_class
        FROM fa_book_controls
       WHERE book_type_code = h_book_type_code;