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: 202

  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: 252

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

Line: 343

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

Line: 372

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

Line: 451

  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;