APPS.EDW_DERIVED_FACT_COLLECT dependencies on DBMS_LOCK

Line 1560: DBMS_LOCK.SLEEP(p_sleep_time);

1556: end loop;
1557: if l_changed then
1558: exit;
1559: elsif l_running then
1560: DBMS_LOCK.SLEEP(p_sleep_time);
1561: else
1562: exit;
1563: end if;
1564: end loop;