APPS.GMD_QCRCOA03_XMLP_PKG SQL Statements

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

Line: 6

    SELECT
      MEANING
    INTO COA_REPORT_TITLE
    FROM
      GEM_LOOKUPS
    WHERE LOOKUP_TYPE = 'GMD_COA_REPORT_TITLE'
      AND LOOKUP_CODE = REPORT_TITLE;

Line: 35

      SELECT
        C.REPORT_TITLE,
        MEANING
      FROM
        GEM_LOOKUPS L,
        GMD_COA_HEADERS C
      WHERE L.LOOKUP_TYPE = 'GMD_COA_REPORT_TITLE'
        AND L.LOOKUP_CODE = C.REPORT_TITLE;

Line: 44

      SELECT
        MEANING
      FROM
        GEM_LOOKUPS L
      WHERE L.LOOKUP_TYPE = 'GMD_COA_REPORT_TITLE'
        AND L.LOOKUP_CODE = 'BLK';

Line: 65

      SELECT
        count(*)
      FROM
        GMD_COA_HEADERS;

Line: 70

      SELECT
        count(*)
      FROM
        GMD_COA_DETAILS;

Line: 75

      SELECT
        count(*)
      FROM
        GMD_COA_SPEC_TEXT;

Line: 80

      SELECT
        count(*)
      FROM
        GMD_COA_RSLT_TEXT;

Line: 85

      SELECT
        count(*)
      FROM
        GMD_COA_SPEC_HDR_TEXT;

Line: 96

      DELETE FROM GMD_COA_HEADERS;

Line: 103

      DELETE FROM GMD_COA_DETAILS;

Line: 110

      DELETE FROM GMD_COA_SPEC_TEXT;

Line: 117

      DELETE FROM GMD_COA_RSLT_TEXT;

Line: 124

      DELETE FROM GMD_COA_SPEC_HDR_TEXT;