[Home] [Help]
1347: IS
1348: /* Cursor to retrieve Defined Balance Id */
1349: CURSOR csr_def_bal_id(p_user_name VARCHAR2) IS
1350: SELECT u.creator_id
1351: FROM ff_user_entities u,
1352: ff_database_items d
1353: WHERE d.user_name = p_user_name
1354: AND u.user_entity_id = d.user_entity_id
1355: AND (u.legislation_code = 'SE' )
1354: AND u.user_entity_id = d.user_entity_id
1355: AND (u.legislation_code = 'SE' )
1356: AND (u.business_group_id IS NULL )
1357: AND u.creator_type = 'B';
1358: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
1359: BEGIN
1360: IF g_debug THEN
1361: hr_utility.set_location(' Entering Function GET_DEFINED_BALANCE_ID',240);
1362: END IF;