APPS.ADI_DISPLAY_REPORT dependencies on FND_PROFILE_OPTION_VALUES

Line 154: g_ServerAddress FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;

150: g_AppsRelease NUMBER;
151: g_UserId INTEGER;
152: g_Language VARCHAR2(100);
153:
154: g_ServerAddress FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%TYPE;
155:
156: TYPE TimeFrameTable IS TABLE OF GL_Periods.Period_Name%TYPE
157: INDEX BY BINARY_INTEGER;
158: TYPE ExpandedTable IS TABLE OF FND_FLEX_VALUES.Parent_Flex_Value_High%TYPE

Line 392: l_query := l_query || ' FND_PROFILE_OPTION_VALUES V ';

388: IF (g_ServerAddress IS NULL) THEN
389: l_query := '';
390: l_query := l_query || 'SELECT V.PROFILE_OPTION_VALUE ';
391: l_query := l_query || 'FROM FND_PROFILE_OPTIONS O, ';
392: l_query := l_query || ' FND_PROFILE_OPTION_VALUES V ';
393: l_query := l_query || 'WHERE O.PROFILE_OPTION_NAME = ''APPS_SERVLET_AGENT'' ';
394: l_query := l_query || 'AND O.START_DATE_ACTIVE <= SYSDATE ';
395: l_query := l_query || 'AND (NVL(O.END_DATE_ACTIVE,SYSDATE) >= SYSDATE) ';
396: l_query := l_query || 'AND (V.LEVEL_ID (+) = 10001 AND V.LEVEL_VALUE (+) = 0) ';