APPS.BIM_PMV_DBI_UTL_PKG SQL Statements

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

Line: 42

/*INSERT INTO bim_param_test values(p_page_parameter_tbl(i).parameter_name,
   p_page_parameter_tbl(i).parameter_value,
   p_page_parameter_tbl(i).parameter_id);*/

Line: 126

/*INSERT INTO bim_param_test values('get_bim_page_params success',
         nvl(l_comp_type,'NULL'),nvl(l_period_type,'NULL'),
         DBMS_UTILITY.get_time,l_country,NULL,null);

Line: 134

/*INSERT INTO bim_param_test values('get_bim_page_params excpetion',
         nvl(l_comp_type,'NULL'),nvl(l_period_type,'NULL'),
         DBMS_UTILITY.get_time,l_country,l_sql_errm,null);

Line: 300

      SELECT sequence
        INTO l_curr_year
        FROM fii_time_ent_year
       WHERE l_as_of_date BETWEEN start_date AND end_date;

Line: 305

      SELECT start_date
        INTO l_date
        FROM fii_time_ent_year
       WHERE sequence = l_curr_year - 3;

Line: 314

      SELECT sequence,
             ent_year_id
        INTO l_curr_qtr, l_curr_year
        FROM fii_time_ent_qtr
       WHERE l_as_of_date BETWEEN start_date AND end_date;

Line: 323

        SELECT start_date
          INTO l_date
          FROM fii_time_ent_qtr
         WHERE sequence = l_curr_qtr + 1
           AND ent_year_id = l_curr_year - 1;

Line: 333

    SELECT p.sequence, q.ent_year_id
      INTO l_curr_period, l_curr_year
      FROM fii_time_ent_period p, fii_time_ent_qtr q
     WHERE p.ent_qtr_id=q.ent_qtr_id
       AND l_as_of_date BETWEEN p.start_date AND p.end_date;

Line: 339

    SELECT p.start_date
      INTO l_date
      FROM fii_time_ent_period p, fii_time_ent_qtr q
     WHERE p.ent_qtr_id = q.ent_qtr_id
       AND p.sequence = l_curr_period + 1
       AND q.ent_year_id = l_curr_year - 1;

Line: 346

/*INSERT INTO bim_param_test values('AOD:'||l_as_of_date,
   'currperiod:'||l_curr_period,
   'return date'||l_date,DBMS_UTILITY.get_time,NULL,NULL,null);

Line: 354

      SELECT start_date
	INTO l_week_start_date
	FROM fii_time_week
       WHERE l_as_of_date BETWEEN start_date AND end_date;

Line: 359

      SELECT start_date
	INTO l_date
	FROM fii_time_week
       WHERE start_date = l_week_start_date - 7 * 12;

Line: 443

  select end_date
  into l_date
  from fii_time_ent_year
  where sequence =
  (select sequence - num_periods
   from fii_time_ent_year
   where as_of_date between start_date and end_date);

Line: 465

 select p.sequence, q.ent_year_id
  into l_curr_period, l_curr_year
  from fii_time_ent_period p, fii_time_ent_qtr q
  where p.ent_qtr_id=q.ent_qtr_id
  and as_of_date between p.start_date and p.end_date;

Line: 471

    select p.end_date
    into l_date
    from fii_time_ent_period p, fii_time_ent_qtr q
    where p.ent_qtr_id=q.ent_qtr_id
    and p.sequence= l_curr_period
    and q.ent_year_id= l_curr_year-2;

Line: 493

  select sequence, ent_year_id
  into l_curr_qtr, l_curr_year
  from fii_time_ent_qtr
  where as_of_date between start_date and end_date;

Line: 498

    select end_date
    into l_date
    from fii_time_ent_qtr
    where sequence=l_curr_qtr
    and ent_year_id=l_curr_year-2;

Line: 504

       select qtr2.end_date
       into l_date
       from fii_time_ent_qtr qtr1, fii_time_ent_qtr qtr2
       where as_of_date between qtr1.start_date and qtr1.end_date
       and qtr2.sequence = qtr1.sequence and qtr2.ent_year_id=qtr1.ent_year_id-2;

Line: 608

select al.meaning  into l_meaning
from bim_r_code_definitions bc ,
as_sales_lead_ranks_vl al
where bc.object_def = al.rank_id
and bc.object_type = 'RANK_DBI' and column_name = p_name;

Line: 629

    SELECT MEANING into l_rev
    FROM FND_LOOKUP_VALUES
    WHERE LOOKUP_TYPE = 'BIM_REVENUE'
    AND   lookup_code=fnd_profile.VALUE('BIM_REVENUE')
    AND   language = USERENV('LANG');

Line: 641

   SELECT  MEANING into l_period
   FROM FND_LOOKUP_VALUES
   WHERE LOOKUP_TYPE = 'BIM_GEN_LOOKUP'
   AND  lookup_code=p_name
   AND   language = USERENV('LANG');

Line: 656

   SELECT  MEANING into l_per_lead
   FROM FND_LOOKUP_VALUES
   WHERE LOOKUP_TYPE = 'BIM_GEN_LOOKUP'
   AND  lookup_code=pld
  AND   language = USERENV('LANG');

Line: 671

  SELECT  MEANING into l_period
   FROM FND_LOOKUP_VALUES
   WHERE LOOKUP_TYPE = 'BIM_GEN_LOOKUP'
   AND    lookup_code=p_name
   AND   language = USERENV('LANG');

Line: 679

   SELECT  MEANING into l_per_lead
   FROM FND_LOOKUP_VALUES
   WHERE LOOKUP_TYPE = 'BIM_GEN_LOOKUP'
   AND    lookup_code=pld
   AND   language = USERENV('LANG');

Line: 693

   SELECT  MEANING into l_per_lead
   FROM FND_LOOKUP_VALUES
   WHERE LOOKUP_TYPE = 'BIM_GEN_LOOKUP'
   AND    lookup_code=pld
   AND   language = USERENV('LANG');

Line: 707

   SELECT  MEANING into l_per_lead
   FROM FND_LOOKUP_VALUES
   WHERE LOOKUP_TYPE = 'BIM_GEN_LOOKUP'
   AND    lookup_code=pld
   AND   language = USERENV('LANG');

Line: 728

       SELECT MEANING
        FROM   fnd_lookup_values
	WHERE  lookup_type = 'BIM_GEN_LOOKUP'
	AND    lookup_code =code
	AND    language = USERENV('LANG');

Line: 749

       select a.name from bis_levels_tl a,bis_levels b
       where
       a.level_id = b.level_id
       and b.short_name =code
       and a.language=USERENV('LANG');