549: /* Bug# 2255068
550: * pa_cc_utils.log_message('150:Get Exp Group and Run Id');
551: * select SUBSTRB(meaning,1,6), pa_burden_sum_run_s.nextval
552: * into exp_group, current_run_id
553: * from pa_lookups
554: * where lookup_type = 'BURDEN_ACCOUNTING'
555: * and lookup_code = 'BS'
556: * and sysdate between start_date_active and nvl(end_date_active,sysdate);
557: * exp_group := exp_group||current_run_id;
797: /*Bug#2255068: Run ids are generated once for each batch*/
798:
799: select SUBSTRB(meaning,1,6), pa_burden_sum_run_s.nextval
800: into exp_group, current_run_id
801: from pa_lookups
802: where lookup_type = 'BURDEN_ACCOUNTING'
803: and lookup_code = 'BS'
804: and sysdate between start_date_active and nvl(end_date_active,sysdate);
805: