APPS.ENG_PARAMETER_ENGCYCLE SQL Statements

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

Line: 118

   select to_date( P_FROM_DATE, DATE_FORMAT ),
          to_date( P_TO_DATE,   DATE_FORMAT )
     into newfromdate, newtodate
     from dual;

Line: 231

    param(i).Value := htf.formSelectopen('p_view_by');

Line: 232

    param(i).Value := param(i).Value || htf.formSelectOption(
                      FND_MESSAGE.get_string( 'BOM', 'TIME_CAP'),
                      NULL, 'VALUE=1');

Line: 235

    param(i).Value := param(i).Value || htf.formSelectOption(
                      FND_MESSAGE.get_string( 'WIP', 'WIP_ORGANIZATION'),
                      NULL, 'VALUE=2');

Line: 238

    param(i).Value := param(i).Value || htf.formSelectclose;

Line: 248

    SELECT to_char(add_months(sysdate, -12), DATE_FORMAT),
           to_char(sysdate, DATE_FORMAT)
      INTO from_date, to_date
      FROM dual;