DBA Data[Home] [Help]

APPS.GL_FEEDER_INFO_PKG SQL Statements

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

Line: 11

       	 SELECT types.encumbrance_type_id, lpad(lkp.meaning, 20)
         FROM   gl_lookups lkp, gl_encumbrance_types types
         WHERE  lkp.lookup_type='LITERAL'
         and types.encumbrance_type_id = 1000
	 and upper(lkp.lookup_code) = UPPER(types.encumbrance_type);
Line: 18

	 SELECT types.encumbrance_type_id, lpad(lkp.meaning, 20)
         FROM   gl_lookups lkp, gl_encumbrance_types types
         WHERE  lkp.lookup_type='LITERAL'
         and types.encumbrance_type_id = 1001
	 and upper(lkp.lookup_code) = UPPER(types.encumbrance_type);
Line: 25

      SELECT lpad(meaning, 20)
      FROM   gl_lookups
      WHERE  lookup_type='LITERAL'
      AND    lookup_code='OTHER';