APPS.ISC_EDW_BOOK_SUM1_F_C dependencies on EDW_LOCAL_INSTANCE

Line 41: FROM EDW_LOCAL_INSTANCE);

37: BEGIN
38: DELETE ISC_EDW_BOOK_SUM1_FSTG
39: WHERE COLLECTION_STATUS = 'LOCAL READY'
40: AND INSTANCE = (SELECT INSTANCE_CODE
41: FROM EDW_LOCAL_INSTANCE);
42: END;
43:
44:
45: --------------------------------------------------

Line 57: FROM edw_local_instance;

53:
54: BEGIN
55: SELECT instance_code
56: INTO l_instance1
57: FROM edw_local_instance;
58:
59: SELECT instance_code
60: INTO l_instance2
61: FROM edw_local_instance@edw_apps_to_wh;

Line 61: FROM edw_local_instance@edw_apps_to_wh;

57: FROM edw_local_instance;
58:
59: SELECT instance_code
60: INTO l_instance2
61: FROM edw_local_instance@edw_apps_to_wh;
62:
63: IF (l_instance1 = l_instance2)
64: THEN RETURN TRUE;
65: END IF;

Line 89: FROM EDW_LOCAL_INSTANCE);

85: UPDATE ISC_EDW_BOOK_SUM1_FSTG
86: SET COLLECTION_STATUS = 'READY'
87: WHERE COLLECTION_STATUS = 'LOCAL READY'
88: AND INSTANCE = (SELECT INSTANCE_CODE
89: FROM EDW_LOCAL_INSTANCE);
90:
91: RETURN(sql%rowcount);
92:
93: EXCEPTION