APPS.GMA_VALID_GRP SQL Statements

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

Line: 109

SELECT
  um_desc
FROM
  sy_uoms_mst
WHERE
    um_code     = p_um
AND delete_mark = 0;

Line: 167

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

Line: 223

SELECT
  orgn_code
FROM
  sy_orgn_mst
WHERE
    orgn_code   = p_orgn_code
AND delete_mark = 0;

Line: 279

SELECT
  co_code
FROM
  sy_orgn_mst
WHERE
    orgn_code   = p_co_code
AND co_code     = p_co_code
AND delete_mark = 0;

Line: 338

SELECT
  co_code
FROM
  sy_orgn_mst
WHERE
    orgn_code   = p_orgn_code
AND co_code     = p_co_code
AND delete_mark = 0;

Line: 402

SELECT
  assignment_type
FROM
  sy_docs_seq
WHERE
    doc_type    = p_doc_type
AND orgn_code   = p_orgn_code
AND delete_mark = 0;

Line: 479

SELECT
  lookup_type
FROM
  gem_lookups
WHERE
  lookup_type   = p_lookup_type
AND lookup_code = p_lookup_code;