APPS.INV_MGD_POS_BUCKET_MDTR SQL Statements

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

Line: 51

SELECT
  period_name
, start_date
, end_date
, start_date
FROM gl_periods
WHERE period_set_name        = p_period_set_name
  AND period_type            = p_period_type
  AND adjustment_period_flag = 'N'
  AND end_date >= p_date_from
ORDER BY end_date;

Line: 94

  SELECT
    gsob.period_set_name
  , gsob.accounted_period_type
  INTO
    x_context_rec.period_set_name
  , x_context_rec.period_type
  FROM gl_sets_of_books gsob
     , org_organization_definitions ood
  WHERE gsob.set_of_books_id = ood.set_of_books_id
    AND organization_id      = p_organization_id;

Line: 406

  x_bucket_tbl.DELETE;