APPS.BIX_UTIL_PKG SQL Statements

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

Line: 46

  SELECT sysdate
  INTO   l_sysdate
  FROM   dual;

Line: 101

  select max(day)
         into l_uwq_max_date
  from   bix_dm_uwq_agent_sum;

Line: 105

    SELECT MAX(collect_end_date) INTO l_collect_max_date
    FROM bix_dm_collect_log
    WHERE object_name = 'BIX_DM_UWQ_GROUP_SUM';

Line: 143

  SELECT to_char(MAX(period_start_date_time),l_date_format)
  INTO   l_max_date
  FROM   bix_dm_agent_call_sum;

Line: 163

  SELECT to_char(MAX(period_start_date_time),l_date_format)
  INTO   l_max_date
  FROM   bix_dm_agent_call_sum;

Line: 205

  select max(day)
         into l_uwq_max_date
  from   bix_dm_uwq_agent_sum;

Line: 209

    SELECT MAX(collect_end_date) INTO l_collect_max_date
    FROM bix_dm_collect_log
    WHERE object_name = 'BIX_DM_UWQ_GROUP_SUM';

Line: 245

  select max(day)
         into l_uwq_max_date
  from   bix_dm_uwq_agent_sum;

Line: 249

    SELECT MAX(collect_end_date) INTO l_collect_max_date
    FROM bix_dm_collect_log
    WHERE object_name = 'BIX_DM_UWQ_GROUP_SUM';

Line: 280

  SELECT to_char(sysdate,l_date_format)
  INTO   l_max_date
  FROM   dual;

Line: 352

  SELECT icx_sec.g_session_id
  INTO   l_session_id
  FROM   dual;

Line: 367

  SELECT meaning
  INTO   l_meaning
  FROM   fnd_lookups
  WHERE  lookup_type = 'BIX_DM_NULL_DESC'
  AND    lookup_code = 'NULL';

Line: 393

  SELECT b.start_date,
         b.end_date,
         a.start_date
  INTO   p_period_start_date,
         l_prev_end_date,
         l_curr_start_date
  FROM   gl_periods a, gl_periods b
  WHERE  a.period_set_name = p_period_set_name
  AND    a.period_type = p_period_type
  AND    a.adjustment_period_flag = 'N'
  AND    trunc(p_date) between a.start_date and a.end_date
  AND    b.period_set_name = a.period_set_name
  AND    b.period_type = a.period_type
  AND    b.adjustment_period_flag = 'N'
  AND    (a.start_date - 1) between b.start_date and b.end_date;

Line: 433

  SELECT start_date
  INTO   p_period_start_date
  FROM   gl_periods
  WHERE  period_set_name = p_period_set_name
  AND    period_type = p_period_type
  AND    adjustment_period_flag = 'N'
  AND    trunc(p_date) between start_date and end_date;

Line: 441

  SELECT sysdate
  INTO   p_period_end_date
  FROM   dual;

Line: 477

  SELECT sysdate
  INTO   l_sysdate
  FROM   dual;

Line: 512

    /* Period Indicator = 11 indicates that user has selected today as reporting period */
    p_start_period := to_char(l_sysdate, 'dd/mm/yyyy') || ' 00:00:00';

Line: 517

    /* Period Indicator = 12 indicates that user has selected yesterday as reporting period */
    p_start_period := to_char(l_sysdate-1, 'dd/mm/yyyy') || ' 00:00:00';

Line: 522

    /* Period Indicator = 13 indicates that user has selected current week as reporting period */
    p_start_period := to_char(trunc(l_sysdate,'IW'),'dd/mm/yyyy') || ' 00:00:00';

Line: 527

    /* Period Indicator = 14 indicates that user has selected previous week as reporting period */
    p_start_period := to_char(trunc(l_sysdate,'IW') - 7,'dd/mm/yyyy') || ' 00:00:00';

Line: 532

    /* Period indicator = 15 indicates user has selected current month as reporting period */
    get_curr_period(l_period_set_name, 'Month', l_sysdate, l_start_date, l_end_date);

Line: 538

    /* Period indicator = 16 indicates user has selected previous month as reporting period */
    get_prev_period(l_period_set_name, 'Month', l_sysdate, l_start_date, l_end_date);

Line: 544

    /* Period indicator = 17 indicates user has selected current quarter as reporting period */
    get_curr_period(l_period_set_name, 'Quarter', l_sysdate, l_start_date, l_end_date);

Line: 550

    /* Period indicator = 18 indicates user has selected previous quarter as reporting period */
    get_prev_period(l_period_set_name, 'Quarter', l_sysdate, l_start_date, l_end_date);

Line: 556

    /* Period indicator = 19 indicates user has selected current year as reporting period */
    get_curr_period(l_period_set_name, 'Year', l_sysdate, l_start_date, l_end_date);

Line: 562

    /* Period indicator = 20 indicates user has selected previous year as reporting period */
    get_prev_period(l_period_set_name, 'Year', l_sysdate, l_start_date, l_end_date);

Line: 634

  SELECT to_char(MAX(period_start_date_time),l_date_format)
  INTO   l_max_date
  FROM   bix_dm_agent_sum;

Line: 658

  SELECT to_char(MAX(period_start_date_time),l_date_format)
  INTO   l_max_date
  FROM   bix_dm_call_sum;

Line: 682

  SELECT to_char(MAX(period_start_date_time),l_date_format)
  INTO   l_max_date
  FROM   bix_dm_agent_sum;

Line: 706

  SELECT to_char(MAX(period_start_date_time),l_date_format)
  INTO   l_max_date
  FROM   bix_dm_call_sum;

Line: 743

     SELECT to_date(p_end_date, p_date_format) - p_numperiods
     INTO   l_start_date
     from dual;

Line: 750

     SELECT trunc(to_date(p_end_date,p_date_format),'IW') - (p_numperiods*7)
     INTO l_start_date
     FROM dual;

Line: 776

	   SELECT start_date
	   INTO l_start_date
	   FROM gl_periods
	   WHERE upper(period_set_name) = upper(l_rpt_calendar)
	   AND upper(period_type) = upper(l_period_type)
        AND    adjustment_period_flag = 'N'
	   AND l_ctl_date BETWEEN start_date and end_date;

Line: 847

     SELECT 'Week of '
		   || to_char(trunc(to_date(p_end_date,p_date_format),'IW'),'DD-MON')
     INTO l_group_by
	FROM dual;

Line: 853

     SELECT to_char(start_date,'MON') ||'-'|| period_year
     INTO l_group_by
     FROM gl_periods
     WHERE upper(period_set_name) = upper(l_rpt_calendar)
     AND upper(period_type) = upper(p_period)
     AND adjustment_period_flag = 'N'
     AND p_end_date BETWEEN start_date and end_date;

Line: 862

     SELECT period_year || '-Q' || period_num
     INTO l_group_by
     FROM gl_periods
     WHERE upper(period_set_name) = upper(l_rpt_calendar)
     AND upper(period_type) = upper(p_period)
     AND adjustment_period_flag = 'N'
     AND p_end_date BETWEEN start_date and end_date;