APPS.PO_DATES_S SQL Statements

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

Line: 27

/* bao - cache values to reduce the number of select statements */
/* Bug 3647086: forward port fix; removed caching logic of the closed

Line: 152

   SELECT application_id
   INTO   x_app_id
   FROM   fnd_application
   WHERE  application_short_name = x_app_name ;

Line: 187

   SELECT ps.closing_status
   INTO   x_closing_status
   FROM   gl_period_statuses ps
   WHERE  ps.application_id = x_app_id
   AND	  ps.adjustment_period_flag = 'N'
   AND    ps.set_of_books_id = x_sob_id
   AND    trunc(x_trx_date) BETWEEN trunc(nvl(ps.start_date, x_trx_date))
                            AND     trunc(nvl(ps.end_date, x_trx_date))
   AND    ps.adjustment_period_flag = 'N';

Line: 235

  /* SELECT glps.closing_status
   INTO   x_closing_status
   FROM   org_acct_periods oap,
          gl_period_statuses glps,
          gl_periods glp
   WHERE  oap.organization_id = x_org_id
   AND    oap.period_set_name  = glp.period_set_name
   AND    oap.period_name = glp.period_name   -- Bug 873654
   AND    glp.period_name = glps.period_name
   AND   (trunc(x_trx_date)
          BETWEEN trunc(oap.period_start_date) AND
          trunc(nvl(oap.period_close_date, oap.schedule_close_date)))
   AND    oap.open_flag = 'Y'
   AND   (trunc(x_trx_date)
         BETWEEN trunc(glps.start_date) AND trunc(glps.end_date))
   AND    glps.set_of_books_id = x_sob_id
   AND    glps.application_id  = x_app_id
   AND    glps.adjustment_period_flag = 'N';

Line: 254

   SELECT oap.open_flag
   INTO   x_open_flag
   FROM   org_acct_periods oap
   WHERE  oap.organization_id = x_org_id
   AND   (trunc(x_trx_date)
          BETWEEN trunc(oap.period_start_date) AND
          trunc(nvl(oap.period_close_date, oap.schedule_close_date)))
   AND    oap.open_flag = 'Y';