762: /* Cursor to retrieve Defined Balance Id */
763: Cursor csr_get_defined_balance_id(csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE)
764: IS
765: SELECT ue.creator_id
766: FROM ff_user_entities ue,
767: ff_database_items di
768: WHERE di.user_name = csr_v_Balance_Name
769: AND ue.user_entity_id = di.user_entity_id
770: AND ue.legislation_code = 'FI'
778: (csr_v_Balance_Name FF_DATABASE_ITEMS.USER_NAME%TYPE
779: ,p_business_group_id NUMBER)
780: IS
781: SELECT ue.creator_id
782: FROM ff_user_entities ue,
783: ff_database_items di
784: WHERE di.user_name = csr_v_Balance_Name
785: AND ue.user_entity_id = di.user_entity_id
786: AND ue.legislation_code is NULL