256:
257: CURSOR c_usr_entity_name
258: IS
259: SELECT user_entity_name
260: FROM ff_user_entities
261: WHERE user_entity_id = p_user_entity_id;
262:
263: CURSOR c_gre_name(c_tax_unit_id VARCHAR2) is
264: SELECT NAME
286:
287:
288:
289:
290: p_item_name ff_user_entities.user_entity_name%TYPE;
291: l_item_name ff_user_entities.user_entity_name%TYPE;
292: l_old_value VARCHAR2(100);
293: l_new_value VARCHAR2(100);
294:
287:
288:
289:
290: p_item_name ff_user_entities.user_entity_name%TYPE;
291: l_item_name ff_user_entities.user_entity_name%TYPE;
292: l_old_value VARCHAR2(100);
293: l_new_value VARCHAR2(100);
294:
295: