APPS.MSC_CL_SUPPLY_ODS_LOAD dependencies on DUAL

Line 36: select (SYSDATE- MSC_CL_COLLECTION.START_TIME) into lv_process_time from dual;

32: into lv_is_job_done
33: from msc_apps_instances
34: where instance_id = MSC_CL_COLLECTION.v_instance_id;
35:
36: select (SYSDATE- MSC_CL_COLLECTION.START_TIME) into lv_process_time from dual;
37:
38: IF lv_process_time > MSC_CL_COLLECTION.p_TIMEOUT/1440.0 THEN
39: lv_is_job_done := MSC_CL_COLLECTION.G_JOB_ERROR;
40: END IF;