APPS.FND_CP_RT_PKG SQL Statements

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

Line: 81

  /* Select and display data */
  procedure verify_values (       run_mode IN varchar2,
                                  duration IN varchar2,
                                  p_num IN varchar2,
                                  p_date IN varchar2,
                                  p_varchar IN varchar2) is

    l_nls_lang          nls_session_parameters.value%TYPE;

Line: 152

    Select Value Into l_nls_lang
    From   Nls_Session_Parameters
    Where  Upper(Parameter) = 'NLS_LANGUAGE';

Line: 157

    Select Value Into l_nls_terr
    From   Nls_Session_Parameters
    Where  Upper(Parameter) = 'NLS_TERRITORY';

Line: 162

    Select Value Into l_nls_num_char
    From   Nls_Session_Parameters
    Where  Upper(Parameter) = 'NLS_NUMERIC_CHARACTERS';

Line: 167

    Select Value Into l_nls_date_fmt
    From   Nls_Session_Parameters
    Where  Upper(Parameter) = 'NLS_DATE_FORMAT';

Line: 172

    Select Value Into l_nls_date_lang
    From   Nls_Session_Parameters
    Where  Upper(Parameter) = 'NLS_DATE_LANGUAGE';

Line: 180

    Select Instance_Name Into l_db_inst
    From   V$Instance;

Line: 208

         Select to_char(SYSDATE + (3/1440), 'DD-MON-YYYY HH24:MI:SS')
         Into   l_rpt_end_time
         From   Dual;