APPS.HRI_OLTP_PMV_QUERY_TIME SQL Statements

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

Line: 55

      '   (SELECT
          TO_CHAR (' || '&' || 'BIS_CURRENT_ASOF_DATE + tro.offset, '''|| 'dd-Mon-YYYY' ||''')
                                                                value
         ,' || '&' || 'BIS_CURRENT_ASOF_DATE + tro.offset       period_as_of_date
         ,' || '&' || 'BIS_PREVIOUS_ASOF_DATE + tro.offset      prev_period_as_of_date
         ,' || '&' || 'BIS_CURRENT_ASOF_DATE + (tro.offset + tro.start_date_offset)
                                                                period_start_date
         ,' || '&' || 'BIS_CURRENT_ASOF_DATE + tro.offset       period_end_date
         ,tro.period_number                                     period_number
         ,-tro.period_number                                     period_order
        FROM
          fii_time_rolling_offsets tro
        WHERE
            tro.period_type = :TIME_PERIOD_TYPE
        AND tro.comparison_type = :TIME_COMPARISON_TYPE
        AND tro.period_number <= :TIME_PERIOD_NUMBER
        UNION ALL
       SELECT
          TO_CHAR (' || '&' || 'BIS_CURRENT_ASOF_DATE - tro.offset, '''|| 'dd-Mon-YYYY' ||''')
                                                                value
         ,' || '&' || 'BIS_CURRENT_ASOF_DATE - tro.offset       period_as_of_date
         ,' || '&' || 'BIS_PREVIOUS_ASOF_DATE - tro.offset      prev_period_as_of_date
         ,' || '&' || 'BIS_CURRENT_ASOF_DATE - (tro.offset - tro.start_date_offset)
                                                                period_start_date
         ,' || '&' || 'BIS_CURRENT_ASOF_DATE - tro.offset       period_end_date
         ,tro.period_number                                     period_number
         ,tro.period_number                                     period_order
        FROM
           fii_time_rolling_offsets tro
        WHERE
             tro.period_type = :TIME_PROJECT_PERIOD_TYPE
        AND tro.comparison_type = :TIME_PROJECT_COMPARISON_TYPE
        AND tro.period_number <= :TIME_PROJECT_PERIOD_NUMBER
        AND tro.period_number <> 0
       )
        ';

Line: 121

      '   (SELECT
          TO_CHAR (' || '&' || 'BIS_CURRENT_ASOF_DATE + tro.offset, '''|| 'dd-Mon-YYYY' ||''')
                                                                value
         ,' || '&' || 'BIS_CURRENT_ASOF_DATE + tro.offset       period_as_of_date
         ,' || '&' || 'BIS_PREVIOUS_ASOF_DATE + tro.offset      prev_period_as_of_date
         ,' || '&' || 'BIS_CURRENT_ASOF_DATE + (tro.offset + tro.start_date_offset)
                                                                period_start_date
         ,' || '&' || 'BIS_CURRENT_ASOF_DATE + tro.offset       period_end_date
         ,tro.period_number                                     period_number
         ,-tro.period_number                                     period_order
        FROM
          fii_time_rolling_offsets tro
        WHERE
            tro.period_type = :TIME_PERIOD_TYPE
        AND tro.comparison_type = :TIME_COMPARISON_TYPE
        AND tro.period_number <= :TIME_PERIOD_NUMBER
        )
     ';

Line: 159

'SELECT /*+ NOPARALLEL(toff) */
 TO_CHAR(&BIS_CURRENT_ASOF_DATE + offset, '''|| 'dd-Mon-YYYY' ||''') value
,&BIS_CURRENT_ASOF_DATE + offset period_as_of_date
,&BIS_PREVIOUS_ASOF_DATE + offset prev_period_as_of_date
,&BIS_CURRENT_ASOF_DATE + (offset + start_date_offset) period_start_date
,&BIS_CURRENT_ASOF_DATE + offset period_end_date
,period_number period_number
,-period_number period_order
FROM
 fii_time_rolling_offsets toff
WHERE period_type = :TIME_PERIOD_TYPE
AND comparison_type = :TIME_COMPARISON_TYPE
AND period_number <= :TIME_PERIOD_NUMBER';

Line: 174

'SELECT
 TO_CHAR(&BIS_CURRENT_ASOF_DATE - offset, '''|| 'dd-Mon-YYYY' ||''') value
,&BIS_CURRENT_ASOF_DATE - offset period_as_of_date
,&BIS_PREVIOUS_ASOF_DATE - offset prev_period_as_of_date
,&BIS_CURRENT_ASOF_DATE - (offset - start_date_offset) period_start_date
,&BIS_CURRENT_ASOF_DATE - offset period_end_date
,period_number period_number
,period_number period_order
FROM fii_time_rolling_offsets
WHERE period_type = :TIME_PROJECT_PERIOD_TYPE
AND comparison_type = :TIME_PROJECT_COMPARISON_TYPE
AND period_number <= :TIME_PROJECT_PERIOD_NUMBER
AND period_number <> 0';