DBA Data[Home] [Help]

APPS.EGO_ITEM_UTIL_PVT SQL Statements

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

Line: 10

    SELECT MEANING INTO l_meaning
    FROM FND_LOOKUP_VALUES
    WHERE LOOKUP_TYPE = p_lookup_type
      AND LOOKUP_CODE = p_lookup_code
      AND LANGUAGE = USERENV('LANG')
      AND VIEW_APPLICATION_ID = 0
      AND SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(p_lookup_type, 0);
Line: 29

    SELECT PARTY_NAME INTO l_user_name
    FROM EGO_USER_V
    WHERE USER_ID = p_user_id;