[Home] [Help]
1567: /* Cursor to retrieve Defined Balance Id */
1568:
1569: CURSOR csr_def_bal_id(p_user_name VARCHAR2) IS
1570: SELECT u.creator_id
1571: FROM ff_user_entities u,
1572: ff_database_items d
1573: WHERE d.user_name = p_user_name
1574: AND u.user_entity_id = d.user_entity_id
1575: AND (u.legislation_code = 'DK' )
1575: AND (u.legislation_code = 'DK' )
1576: AND (u.business_group_id IS NULL )
1577: AND u.creator_type = 'B';
1578:
1579: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
1580:
1581: BEGIN
1582:
1583: IF g_debug THEN