APPS.GMF_FND_SEGMENT_INFO SQL Statements

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

Line: 7

      SELECT  fnd.segment_name, fnd.segment_num
      FROM fnd_id_flex_segments fnd,gl_sets_of_books gls
      WHERE    gls.name=sobname    AND
            gls.chart_of_accounts_id=fnd.id_flex_num  AND
            fnd.segment_name=nvl(segmentname,fnd.segment_name) AND
            fnd.creation_date  BETWEEN
            nvl(startdate,fnd.creation_date)  AND
            nvl(enddate,fnd.creation_date);

Line: 23

        SELECT    fnd.segment_num
        INTO      segmentnum
        FROM     fnd_id_flex_segments fnd,
              gl_sets_of_books gls
        WHERE    gls.name=sobname
        AND     gls.chart_of_accounts_id=fnd.id_flex_num
        AND     fnd.segment_name=segmentname;