DBA Data[Home] [Help]

APPS.OPI_EDW_OPM_JOB_RSRC_F_C dependencies on EDW_LOCAL_INSTANCE

Line 19: FROM edw_local_instance;

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

Line 22: FROM edw_local_instance@edw_apps_to_wh;

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