APPS.AP_WEB_FND_LOOKUPS_PKG SQL Statements

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

Line: 10

 *    - For performance purpose, we embeded the select statement in this
 *	function instead of calling a procedure
 *  Input:
 *    p_lookup_code - Lookup Code
 *  Output:
 *    Meaning for the Lookup Code
 *  Assumption:
 *    None
 -----------------------------------------------------------*/
FUNCTION getYesNoMeaning(p_lookup_code  IN lookups_code) RETURN lookups_meaning
IS
  l_langCode 			  VARCHAR2(100);

Line: 32

      SELECT MEANING
      INTO g_yesMeaning
      FROM FND_LOOKUPS
      WHERE LOOKUP_TYPE = 'YES_NO'
      AND LOOKUP_CODE = 'Y';

Line: 38

      SELECT MEANING
      INTO g_noMeaning
      FROM FND_LOOKUPS
      WHERE LOOKUP_TYPE = 'YES_NO'
      AND LOOKUP_CODE = 'N';