675: l_database_item_suffix pay_balance_dimensions.database_item_suffix%type;
676: l_dimension_name pay_balance_dimensions.dimension_name%type;
677: l_route_id number;
678: l_balance_dimension_id number;
679: l_route_text ff_routes.text%type;
680: l_dimension_type pay_balance_dimensions.dimension_type%type;
681: l_expiry_checking_level pay_balance_dimensions.expiry_checking_level%type;
682: l_expiry_checking_code pay_balance_dimensions.expiry_checking_code%type;
683: l_description pay_balance_dimensions.description%type;
715: || ' RESET'
716: || TO_CHAR(p_frequency, '00')
717: || ' USER-REG';
718: -- ---------------------------
719: -- INSERT INTO FF_ROUTES --
720: -- ---------------------------
721: select ff_routes_s.nextval
722: into l_route_id
723: from dual;
717: || ' USER-REG';
718: -- ---------------------------
719: -- INSERT INTO FF_ROUTES --
720: -- ---------------------------
721: select ff_routes_s.nextval
722: into l_route_id
723: from dual;
724: --
725: select pay_balance_dimensions_s.nextval
732: WHERE TARGET.assignment_action_id = &B1
733: AND TARGET.balance_type_id = &U1
734: AND TARGET.balance_dimension_id = ' || to_char(l_balance_dimension_id);
735: --
736: insert into ff_routes(
737: route_id,
738: route_name,
739: user_defined_flag,
740: description,