APPS.PA_PERIOD_PROCESS_PKG SQL Statements

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

Line: 77

    select nvl(imp.same_pa_gl_period,'N')
    into l_return_value
    from pa_implementations_all imp
    where imp.org_id = nvl(p_org_id, -99);                       /*5368274*/

Line: 105

PROCEDURE Update_PA_Period_Status is

 cursor c_periods is
 select b.period_name, b.closing_status, b.set_of_books_id ,
        b.last_update_date, b.last_updated_by, b.last_update_login /* added bug 3111150 */
 from pa_periods a, gl_period_statuses b
 where a.period_name = b.period_name
 and b.application_id = 8721
 and b.set_of_books_id = (select set_of_books_id from pa_implementations)
 and a.start_date = b.start_date
 and a.end_Date = b.end_date
 and a.status <> b.closing_status;

Line: 121

 l_LastUpdateDate      PA_PLSQL_DATATYPES.DateTabTyp; /* added bug 3111150 */

Line: 122

 l_LastUpdatedBy       PA_PLSQL_DATATYPES.IdTabTyp;   /* added bug 3111150 */

Line: 123

 l_LastUpdateLogin     PA_PLSQL_DATATYPES.IdTabTyp;   /* added bug 3111150 */

Line: 128

    l_PeriodTab.Delete;

Line: 129

    l_StatusTab.Delete;

Line: 130

    l_SobId.Delete;

Line: 131

    l_LastUpdateDate.Delete;    /* added bug 3111150 */

Line: 132

    l_LastUpdatedBy.Delete;     /* added bug 3111150 */

Line: 133

    l_LastUpdateLogin.Delete;   /* added bug 3111150 */

Line: 139

        l_LastUpdateDate,    /* added bug 3111150 */
        l_LastUpdatedBy,     /* added bug 3111150 */
        l_LastUpdateLogin    /* added bug 3111150 */
    limit 200;

Line: 149

      update pa_periods_all pp
      set pp.status = l_StatusTab(i),
          pp.last_update_date = l_LastUpdateDate(i),     /* added bug 3111150 */
          pp.last_updated_by = l_LastUpdatedBy(i),       /* added bug 3111150 */
          pp.last_update_login = l_LastUpdateLogin(i)    /* added bug 3111150 */
      where pp.period_name = l_PeriodTab(i)
      and pp.org_id in (select imp.org_id
                       from pa_implementations_all imp
                       where nvl(imp.same_pa_gl_period,'N') = 'Y'
                       and imp.set_of_books_id = l_SobId(i));

Line: 171

end Update_PA_Period_Status;

Line: 207

   SELECT pa.period_name
     FROM pa_periods pa,
          gl_period_statuses gl
     WHERE gl.set_of_books_id=p_sob_id
       AND gl.application_id=8721
       AND pa.period_name=gl.period_name
       AND pa.status <>gl.closing_status;

Line: 217

  SELECT Period_Set_Name,
         Accounted_Period_Type
   INTO lv_gl_period_set_name,
         lv_gl_period_type
    FROM gl_sets_of_books
      WHERE Set_of_Books_ID=p_sob_id;