APPS.GMF_ALLOC_PROCESS_PRIVATE SQL Statements

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

Line: 45

      SELECT segment_delimiter
      FROM   gl_plcy_mst
      WHERE  co_code =  v_co_code;

Line: 50

      SELECT COUNT(1)
      FROM   gl_plcy_seg
      WHERE  co_code  = v_co_code
             AND type = v_type;

Line: 56

      SELECT segment_no,
             length,
             short_name
      FROM   gl_plcy_seg
      WHERE  co_code  = v_co_code
		     AND type = v_type
      ORDER BY 1 ASC;

Line: 65

      SELECT COUNT(1)
      FROM   gl_plcy_seg
      WHERE  co_code = v_co_code;