APPS.FFDBITEM dependencies on FF_USER_ENTITIES

Line 213: l_user_entity_id FF_USER_ENTITIES.USER_ENTITY_ID%type;

209: p_leg_code in varchar2,
210: p_item_info out FFITEM_INFO_T) is
211: --
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;

Line 215: l_notfound_allowed FF_USER_ENTITIES.NOTFOUND_ALLOWED_FLAG%type;

211: --
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

Line 228: FF_USER_ENTITIES UE,

224: FR.ROUTE_ID,
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