APPS.BIM_PREV_PERIODS_PKG SQL Statements

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

Line: 36

SELECT  period_num
        ,period_year
        ,quarter_num
 INTO    l_current_start_num
        ,l_current_start_year
        ,l_current_start_quarter_num
 FROM    gl_periods
 WHERE   start_date  =   p_start_date
 AND     period_type = p_period_type
 AND    rownum < 2;

Line: 52

 SELECT  period_num
        ,period_year
        ,quarter_num
 INTO    l_current_END_num
        ,l_current_END_year

        ,l_current_END_quarter_num
 FROM   gl_periods
 WHERE  END_date  =   p_END_date
 AND    period_type = p_period_type
 AND   rownum < 2;

Line: 134

 SELECT start_date
 INTO   p_prev_start_date
 FROM   gl_periods
 WHERE  period_num  =  l_prev_start_num
 AND    period_year =  l_prev_start_year
 AND    period_type =  p_period_type
 AND    rownum < 2;

Line: 147

 SELECT END_date
 INTO   p_prev_END_date
 FROM   gl_periods
 WHERE  period_num  =  l_prev_END_num
 AND    period_year =  l_prev_END_year
 AND    period_type =  p_period_type
 AND    rownum < 2;