APPS.GMA_GLOBAL_GRP SQL Statements

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

Line: 69

SELECT
  last_assigned
, format_size
, pad_char
FROM
  sy_docs_seq
WHERE
    doc_type  = p_doc_type
AND orgn_code = p_orgn_code;

Line: 82

  UPDATE sy_docs_seq
  SET
    last_assigned = last_assigned + 1
  WHERE
    doc_type  = p_doc_type AND
    orgn_code = p_orgn_code;

Line: 135

SELECT
  *
FROM
  sy_reas_cds
WHERE
  reason_code   = p_reason_code AND
  delete_mark = 0;

Line: 189

SELECT
  user_id
FROM
  fnd_user
WHERE
  user_name = p_user_name;