DBA Data[Home] [Help]

APPS.OPI_EDW_OPMCOGS_F_C dependencies on EDW_LOCAL_INSTANCE

Line 20: FROM edw_local_instance;

16: l_source Varchar2(100) :=Null;
17: l_Target Varchar2(100) :=Null;
18: BEGIN
19: SELECT instance_code INTO l_source
20: FROM edw_local_instance;
21:
22: SELECT instance_code INTO l_target
23: FROM edw_local_instance@edw_apps_to_wh;
24:

Line 23: FROM edw_local_instance@edw_apps_to_wh;

19: SELECT instance_code INTO l_source
20: FROM edw_local_instance;
21:
22: SELECT instance_code INTO l_target
23: FROM edw_local_instance@edw_apps_to_wh;
24:
25: IF (l_source = l_target) THEN
26: RETURN TRUE;
27: END IF;