DBA Data[Home] [Help]

APPS.MSD_COMMON_UTILITIES dependencies on MSD_SR_LEVEL_PK_S

Line 458: select MSD_SR_LEVEL_PK_S.nextval

454: begin
455:
456: -- loop until unique key is generated
457: while (v_count > 0) loop
458: select MSD_SR_LEVEL_PK_S.nextval
459: into v_ret
460: from sys.dual;
461:
462: select count(*)

Line 489: select MSD_SR_LEVEL_PK_S.nextval

485:
486: -- loop until unique key is generated from staging and fact table
487: while ( v_count1 > 0 OR v_count2 > 0) loop
488:
489: select MSD_SR_LEVEL_PK_S.nextval
490: into v_next
491: from sys.dual;
492:
493: select count(*)