APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_ST_REGIONS

Line 384: FROM MSC_ST_REGIONS msr

380: msr.COUNTY,
381: msr.SR_INSTANCE_ID,
382: msr.REFRESH_NUMBER,
383: msr.ZONE_USAGE
384: FROM MSC_ST_REGIONS msr
385: WHERE msr.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
386:
387: /* Changed Refresh_id to Refresh_number */
388: CURSOR c8 IS

Line 1504: UPDATE MSC_ST_REGIONS

1500: IF ((MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh)) THEN
1501:
1502: BEGIN -- load for MSC_REGIONS
1503: /* Updating Who cols of Staging Tables */
1504: UPDATE MSC_ST_REGIONS
1505: SET
1506: REFRESH_NUMBER = MSC_CL_COLLECTION.v_last_collection_id,
1507: LAST_UPDATE_DATE = MSC_CL_COLLECTION.v_current_date,
1508: LAST_UPDATED_BY = MSC_CL_COLLECTION.v_current_user,