APPS.FFDBITEM dependencies on FF_ROUTES

Line 216: l_route_id FF_ROUTES.ROUTE_ID%type;

212: l_data_type FF_DATABASE_ITEMS.DATA_TYPE%type;
213: l_user_entity_id FF_USER_ENTITIES.USER_ENTITY_ID%type;
214: l_null_allowed FF_DATABASE_ITEMS.NULL_ALLOWED_FLAG%type;
215: l_notfound_allowed FF_USER_ENTITIES.NOTFOUND_ALLOWED_FLAG%type;
216: l_route_id FF_ROUTES.ROUTE_ID%type;
217: l_definition_text FF_DATABASE_ITEMS.DEFINITION_TEXT%type;
218: l_route_text varchar2(8000);
219: cursor c1 is
220: SELECT DI.DATA_TYPE,

Line 229: FF_ROUTES FR

225: DI.DEFINITION_TEXT,
226: FR.TEXT
227: FROM FF_DATABASE_ITEMS DI,
228: FF_USER_ENTITIES UE,
229: FF_ROUTES FR
230: WHERE DI.USER_ENTITY_ID = UE.USER_ENTITY_ID
231: AND UE.ROUTE_ID = FR.ROUTE_ID
232: AND DI.USER_NAME = p_item_name
233: AND ( (UE.LEGISLATION_CODE IS NULL AND UE.BUSINESS_GROUP_ID IS NULL)