431: -- syenamar
432:
433: l_stmt := null;
434: l_stmt := 'select distinct price_list_name price_list_name
435: from msd_dem_price_lists_gtt';
436:
437:
438: /*l_list2 := null;
439:
525: as
526:
527: cursor count_price_lists is
528: select count(*)
529: from msd_dem_price_lists;
530:
531: l_count_price_lists number;
532:
533: cursor price_list_cur is
531: l_count_price_lists number;
532:
533: cursor price_list_cur is
534: select price_list_name
535: from msd_dem_price_lists;
536:
537: acc_list varchar2(5000);
538: unacc_list varchar2(5000);
539: