2422: begin
2423: select to_number(ue.creator_id)
2424: into l_defined_balance_id
2425: from ff_user_entities ue,
2426: ff_database_items di
2427: where di.user_name = 'PAYMENTS_ASG_GRE_RUN'
2428: and ue.user_entity_id = di.user_entity_id
2429: and ue.creator_type = 'B'
2430: and nvl(ue.legislation_code,'US') = 'US';
2670: begin
2671: select to_number(ue.creator_id)
2672: into l_defined_balance_id
2673: from ff_user_entities ue,
2674: ff_database_items di
2675: where di.user_name = 'PAYMENTS_ASG_GRE_RUN'
2676: and ue.user_entity_id = di.user_entity_id
2677: and ue.creator_type = 'B'
2678: and nvl(ue.legislation_code,'US') = 'US';