APPS.IBE_BI_PMV_UTIL_PVT SQL Statements

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

Line: 15

/** Global variable to cache currency count when 'ALL' minisite is selected **/
g_all_curr_count number := -9999;

Line: 18

/** Global variable to cache currency code when 'ALL' minisite is selected **/
g_all_curr_code varchar2(15);

Line: 55

		   SELECT COUNT(distinct f_curr.currency_code) new_count_number
		   INTO g_all_curr_count
		   FROM  ibe_bi_currency_v f_curr
		   WHERE not exists (select b.org_id
	                  from ibe_bi_msiteorg_mv b
	                  where b.msite_id = f_Curr.msite_id
	                  MINUS
        	          select a.organization_id
                	  from per_organization_list a
	                  where a.security_profile_id =
        	            g_mo_sec_profile);

Line: 76

	            select distinct currency_code
		    into g_all_curr_code
	            FROM  ibe_bi_currency_v f_curr
	            WHERE currency_code <> g_gp_currency
 				and currency_code <> g_gs_currency
		      and not exists (select b.org_id
		                  from ibe_bi_msiteorg_mv b
		                  where b.msite_id = f_Curr.msite_id
	        	          MINUS
        	        	  select a.organization_id
	                	  from per_organization_list a
		                  where a.security_profile_id =
        		            g_mo_sec_profile);

Line: 102

		SELECT count(distinct currency_code) count_number
		INTO g_msite_curr_count_table(l_msite_id)
	   	FROM ibe_bi_currency_v
   		WHERE msite_id = l_msite_id;

Line: 117

	         select  currency_code
		 into g_msite_curr_table(l_msite_id)
        	 FROM ibe_bi_currency_v
	         WHERE msite_id = to_number(l_MSITE_ID)
                  and currency_code <> g_gp_currency
			   and currency_code <> g_gs_currency;

Line: 202

  Select (end_date - p_date) timespan,
         sequence
    From  FII_TIME_ENT_YEAR
    Where  p_date BETWEEN start_date AND end_date;

Line: 223

  SELECT end_date - p_date timespan,
    sequence,
    ent_year_id,
    start_date
    FROM  FII_TIME_ENT_qtr
    WHERE  p_date BETWEEN start_date AND end_date;

Line: 232

    SELECT start_date
      FROM  FII_TIME_ENT_qtr
      WHERE  sequence = p_sequence
      AND  ent_year_id = p_year_id;

Line: 291

  SELECT end_date - p_date timespan,
    sequence,
    ent_year_id,

    start_date
    FROM  FII_TIME_ENT_period
    WHERE  p_date BETWEEN start_date AND end_date;

Line: 302

  SELECT start_date
  FROM  FII_TIME_ENT_PERIOD
  WHERE  sequence = p_sequence
    AND  ent_year_id = p_year_id;

Line: 357

  select w.end_date - p_date timespan,
         w.start_date,
                 w.sequence,
                 p.year445_id
  from fii_time_week w, fii_time_p445 p

  where w.period445_id = p.period445_id
  and   p_date between w.start_date and w.end_date ;

Line: 368

   SELECT w.start_date
     from fii_time_week w, fii_time_p445 p
    where w.period445_id = p.period445_id
      and w.sequence = p_sequence
      and p.year445_id = p_year-1;