APPS.GL_CI_WORKFLOW_PKG SQL Statements

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

Line: 42

/***    select oracle_username
    into applSysSchema
    from fnd_oracle_userid
    where read_only_flag = 'U'
    and oracle_id = 900;

Line: 48

    v_SQL := 'select oracle_username from fnd_oracle_userid@' || l_dblink ||
              ' where read_only_flag = :flag' ||
              ' and oracle_id = :or_id';

Line: 114

    Select
       consolidation_id,
       consolidation_set_id,
       from_period_name,
       to_period_name,
       target_resp_name,
       target_user_name,
       target_database_name
    From GL_CONSOLIDATION_HISTORY
    Where REQUEST_ID = p_cons_request_Id;

Line: 175

      v_SQL := 'select name from gl_consolidation' ||
            ' where consolidation_id = :id';

Line: 180

      v_SQL := 'select name from gl_consolidation_sets' ||
            ' where consolidation_set_id = :id';

Line: 185

   v_SQL := 'select name from gl_ledgers' ||
            ' where ledger_id = :id';

Line: 189

   v_SQL := 'select domain_name ' ||
              'from rg_database_links ' ||
              'where name = :pd';

Line: 195

   v_SQL := 'select user_je_source_name from gl_je_sources ' ||
               'WHERE je_source_name = :s_name';

Line: 212

      v_SQL := 'select email_address from fnd_user@' || p_dblink || '.world' ||
            ' where user_name = :name';

Line: 224

   v_SQL := 'select name from v$database';

Line: 354

   SELECT user_name
   FROM fnd_user
   WHERE user_id = l_user_id;

Line: 481

      SELECT gl_cit_notify_s.NEXTVAL
      FROM dual;