APPS.AR_CREATE_ACCTING_SRS SQL Statements

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

Line: 81

     INSERT INTO ar_submission_ctrl_gt
     (worker_id         , --org_id
      batch_id          , --batch_id
      script_name       , --script_name
      status            , --
      order_num         , --order helper number
      request_id        , --request_id
      table_name        ) --table_name
      VALUES
     (p_org_id,
      NULL,
      'ARTERRPM',
      'SUBMITTED',
      1,
      x_out_request_id,
      'REVREC');

Line: 127

     INSERT INTO ar_submission_ctrl_gt
     (worker_id         , --org_id
      batch_id          , --batch_id
      script_name       , --script_name
      status            , --
      order_num         , --order helper number
      request_id        , --request_id
      table_name        ) --table_name
      VALUES
     (p_org_id,
      NULL,
      'ARREVSWP',
      'SUBMITTED',
      2,
      x_out_request_id,
      'REVCONTEN');

Line: 191

  SELECT application_name
    FROM FND_APPLICATION_VL FVL
   WHERE application_id = p_src_app;

Line: 196

  SELECT name
    FROM gl_ledgers
   WHERE ledger_id = p_ledger_id;

Line: 204

  SELECT name
    FROM xla_event_class_grps_vl
    WHERE application_id = p_app_id
    AND event_class_group_code = p_proc_categ;

Line: 210

  SELECT meaning
    FROM xla_lookups
    WHERE lookup_type = p_lookup_type
    AND lookup_code = p_lookup_code;

Line: 219

  SELECT 'Y'
    FROM gl_period_statuses  glp
   WHERE glp.application_id  = 222
     AND p_date     BETWEEN glp.start_date AND glp.end_date
     AND glp.set_of_books_id = p_ledger
     AND glp.closing_status  IN ('O','F');

Line: 321

  SELECT lower(iso_language),iso_territory
    INTO   l_iso_language,
           l_iso_territory
    FROM   FND_LANGUAGES
   WHERE  language_code = USERENV('LANG');

Line: 412

  SELECT request_id
    FROM ar_submission_ctrl_gt
   WHERE status      <> 'COMPLETE'
     AND script_name = p_sub_name;

Line: 441

        UPDATE ar_submission_ctrl_gt
           SET status = 'COMPLETE'
         WHERE request_id = l_req_id;

Line: 520

  SELECT DISTINCT arsys.org_id
    FROM ar_system_parameters_all arsys,
         mo_glob_org_access_tmp   mo
   WHERE arsys.set_of_books_id = p_ledger_id
     AND arsys.org_id          = mo.organization_id;