APPS.BIS_PMV_TIME_LEVELS_PVT SQL Statements

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

Line: 96

      l_sql := 'select id, value from fii_time_week_v where :1 between start_date and end_date';

Line: 112

      l_sql := 'select id, value from fii_time_month_v where :1 between start_date and end_date';

Line: 128

      l_sql := 'select id, value from fii_time_qtr_v where :1 between start_date and end_date';

Line: 145

      l_sql := 'select id, value from fii_time_year_v where :1 between start_date and end_date';

Line: 345

      l_sql := 'select sequence from fii_time_ent_year where :1 between start_date and end_date';

Line: 347

      l_sql := 'select min(start_date) from fii_time_ent_year where sequence >= :l_curr_year-3';

Line: 351

      l_sql := 'select sequence, ent_year_id from fii_time_ent_qtr where :p_asof_date between start_date and end_date';

Line: 354

         l_sql := 'select start_date from (select start_Date from fii_time_ent_qtr where ((sequence >=:l_curr_qtr+1 and '||
                  ' ent_year_id = :l_curr_year-1) or (sequence>=1 and ent_year_id = :l_curr_year)) order by start_date) '||
                  ' where rownum <=1 ';

Line: 359

         l_sql := 'select start_date from (select start_date from fii_time_ent_qtr where ((sequence >=:l_curr_qtr+1 and '||
                  ' ent_year_id = :l_curr_year-2) or (sequence>=1 and ent_year_id = :l_curr_year-1)) order by start_date) '||
                  ' where rownum <=1 ';

Line: 366

      l_sql := 'select p.sequence,q.ent_year_id FROM fii_time_ent_period p , fii_time_ent_qtr q '||
               ' where p.ent_qtr_id=q.ent_qtr_id  and :p_asof_date between p.start_Date and p.end_date';

Line: 369

      l_sql := 'SELECT start_date FROM (select p.start_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) or '||
               ' (p.sequence >= 1 and q.ent_year_id = :l_curr_year)) order by p.start_date) '||
               ' where rownum <= 1';

Line: 377

     l_sql := 'select start_Date from fii_time_Week where :p_asof_date between start_date and end_date';

Line: 379

     l_sql := 'select min(start_date) from fii_time_Week where start_date >= :l_week_start_Date-7*12';