557: l_defined_balance_id NUMBER;
558: l_legislation_code PER_BUSINESS_GROUPS.legislation_code%TYPE;
559: cursor csr_defined_balance_id is
560: select UE.creator_id
561: from ff_user_entities UE,
562: ff_database_items DI
563: where DI.user_name = p_item_name
564: and UE.user_entity_id = DI.user_entity_id
565: and UE.creator_type = 'B'
635: p_effective_date in date )
636: return number is
637: cursor csr_defined_balance is
638: select UE.creator_id
639: from ff_user_entities UE,
640: ff_database_items DI
641: where DI.user_name = p_item_name
642: and UE.user_entity_id = DI.user_entity_id
643: and UE.creator_type = 'B';