[Home] [Help]
299: -- Cursor to retrieve user_entity_id given name
300: CURSOR c_user_entity_name_id(p_user_entity_name VARCHAR2,
301: p_legislation_code VARCHAR2) IS
302: select user_entity_id
303: from ff_user_entities
304: where user_entity_name = p_user_entity_name
305: and (legislation_code = p_legislation_code or
306: ( legislation_code is null and p_legislation_code is null ))
307: and business_group_id IS NULL;
800: -- given a route id find formulas using that route and delete compiled info and
801: -- fdi usages for that. Used when updating a route.
802: CURSOR c_formula_id ( p_route_id number) is
803: select /*+ ORDERED
804: INDEX(C FF_USER_ENTITIES_FK1)
805: INDEX(B FF_DATABASE_ITEMS_FK1)
806: INDEX(A FF_FDI_USAGES_F_N50) */
807: distinct a.formula_id
808: from ff_user_entities c,
804: INDEX(C FF_USER_ENTITIES_FK1)
805: INDEX(B FF_DATABASE_ITEMS_FK1)
806: INDEX(A FF_FDI_USAGES_F_N50) */
807: distinct a.formula_id
808: from ff_user_entities c,
809: ff_database_items b,
810: ff_fdi_usages_f a
811: where a.item_name = b.user_name
812: and a.usage = 'D'
821: -- code dbitems.
822: select distinct fdi.formula_id from
823: ff_fdi_usages_f fdi
824: ,ff_database_items dbi
825: ,ff_user_entities ue
826: ,ff_formulas_f f
827: where fdi.ITEM_NAME = p_user_name
828: and fdi.USAGE = 'D'
829: and ue.USER_ENTITY_ID = dbi.USER_ENTITY_ID