APPS.BIX_PMV_AO_AURTR_PRTLT_PKG SQL Statements

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

Line: 64

   l_session_where_clause := l_session_where_clause || ' AND campaign_id in (select source_code_for_id from
   ams_source_codes where source_code_id IN (:l_source_code_id) and arc_source_code_for=''CAMP'' and active_flag=''Y'' ) ';

Line: 75

      SELECT fii1.name                                  VIEWBY,
      round(sum(nvl(CURR_LOGIN,0)-nvl(CURR_IDLE,0))*100/
      decode(sum(CURR_LOGIN),0,NULL,sum(CURR_LOGIN)),1) BIX_PMV_AO_AVAILRATE,
      round(sum(nvl(PREV_LOGIN,0)-nvl(PREV_IDLE,0))*100/
	 decode(sum(PREV_LOGIN),0,NULL,sum(PREV_LOGIN)),1) BIX_PMV_AO_PREVAVAILRATE,
      round(sum(nvl(CURR_LOGIN,0)-nvl(CURR_IDLE,0)-nvl(CURR_AVAIL,0))*100/
      decode(sum(CURR_LOGIN),0,NULL,sum(CURR_LOGIN)),1) BIX_PMV_AO_UTILRATE,
      round(sum(nvl(PREV_LOGIN,0)-nvl(PREV_IDLE,0)-nvl(PREV_AVAIL,0))*100/
      decode(sum(PREV_LOGIN),0,NULL,sum(PREV_LOGIN)),1) BIX_PMV_AO_PREVUTILRATE
      FROM
            (
              /*--
              --Select the agent session measures
              --*/
              SELECT fii1.sequence,
                    SUM( CASE when
                         (





.start_date between &BIS_CURRENT_REPORT_START_DATE
                                             and &BIS_CURRENT_ASOF_DATE
                          )
                               then
                     LOGIN_TIME
                               else
				0
                               end
                         ) CURR_LOGIN,
                    SUM( CASE when
                         (
                          fii1.start_date between &BIS_CURRENT_REPORT_START_DATE
                                             and &BIS_CURRENT_ASOF_DATE
                          )
                               then
                    WORK_TIME
                               else
				0
                               end
                         ) CURR_WORK,
                    SUM( CASE when
                         (
                          fii1.start_date between &BIS_CURRENT_REPORT_START_DATE
                                             and &BIS_CURRENT_ASOF_DATE
                          )
                               then
                    AVAILABLE_TIME
                               else
				0
                               end
                         ) CURR_AVAIL,
                    SUM( CASE when
                         (
                          fii1.start_date between &BIS_CURRENT_REPORT_START_DATE
                                             and &BIS_CURRENT_ASOF_DATE
                          )
                               then
                     IDLE_TIME
                               else
				0
                               end
                         ) CURR_IDLE,
                    SUM( CASE when
                         (
                          fii1.start_date between &BIS_PREVIOUS_REPORT_START_DATE
                                             and &BIS_PREVIOUS_ASOF_DATE
                          )
                               then
                     LOGIN_TIME
                               else
				0
                               end
                         ) PREV_LOGIN,
                    SUM( CASE when
                         (
                          fii1.start_date between &BIS_PREVIOUS_REPORT_START_DATE
                                             and &BIS_PREVIOUS_ASOF_DATE
                          )
                               then
                    WORK_TIME
                               else
				0
                               end
                         ) PREV_WORK,
                    SUM( CASE when
                         (
                          fii1.start_date between &BIS_PREVIOUS_REPORT_START_DATE
                                             and &BIS_PREVIOUS_ASOF_DATE
                          )
                               then
                    AVAILABLE_TIME
                               else
				0
                               end
                         ) PREV_AVAIL,
                    SUM( CASE when
                         (
                          fii1.start_date between &BIS_PREVIOUS_REPORT_START_DATE
                                             and &BIS_PREVIOUS_ASOF_DATE
                          )
                               then
                     IDLE_TIME
                               else
				0
                               end
                         ) PREV_IDLE
              FROM  ';

Line: 225

      SELECT fii1.name                                  VIEWBY,
      round(sum(nvl(CURR_LOGIN,0)-nvl(CURR_IDLE,0))*100/
      decode(sum(CURR_LOGIN),0,NULL,sum(CURR_LOGIN)),1) BIX_PMV_AO_AVAILRATE,
	 NULL BIX_PMV_AO_PREVAVAILRATE,
      round(sum(nvl(CURR_LOGIN,0)-nvl(CURR_IDLE,0)-nvl(CURR_AVAIL,0))*100/
      decode(sum(CURR_LOGIN),0,NULL,sum(CURR_LOGIN)),1) BIX_PMV_AO_UTILRATE,
	 NULL BIX_PMV_AO_PREVUTILRATE
      FROM
            (
              /*--
              --Select the agent session measures
              --*/
              SELECT fii1.name,
                    SUM(LOGIN_TIME) CURR_LOGIN,
                    SUM(WORK_TIME) CURR_WORK,
                    SUM( AVAILABLE_TIME) CURR_AVAIL,
                    SUM( IDLE_TIME ) CURR_IDLE
              FROM  ';