APPS.GMDOPVAL_PUB SQL Statements

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

Line: 33

  SELECT 1
  FROM   SYS.DUAL
  WHERE  EXISTS (SELECT 1
                 FROM   gmd_operations
                 WHERE  oprn_no = poprn_no
                        AND oprn_vers = poprn_vers);

Line: 82

  SELECT 1
  FROM   SYS.DUAL
  WHERE  EXISTS (SELECT 1
                 FROM   fm_oprn_cls
                 WHERE  oprn_class = poprn_class
                        AND delete_mark = 0);

Line: 131

    SELECT 1
    FROM   SYS.DUAL
    WHERE EXISTS (SELECT 1
                  FROM   fm_actv_mst
                  WHERE  activity = pactivity
                         AND delete_mark = 0);

Line: 183

    SELECT 1
    FROM   SYS.DUAL
    WHERE EXISTS (SELECT 1
                  FROM   cr_rsrc_mst
                  WHERE  resources = presource
                         AND delete_mark = 0);

Line: 237

  SELECT 1
  FROM   SYS.DUAL
  WHERE  EXISTS (SELECT 1
                 FROM   cm_cmpt_mst
                 WHERE  cost_cmpntcls_code = pcost_cmpntcls_code
                        AND delete_mark = 0);

Line: 288

  SELECT 1
  FROM   SYS.DUAL
  WHERE  EXISTS (SELECT 1
                 FROM   cm_alys_mst
                 WHERE  cost_analysis_code = pcost_analysis_code
                        AND delete_mark=0);