APPS.FII_AP_SCH_PAYMTS_F_C dependencies on EDW_LOCAL_INSTANCE

Line 47: FROM EDW_LOCAL_INSTANCE);

43: BEGIN
44: DELETE FII_AP_SCH_PAYMTS_FSTG
45: WHERE COLLECTION_STATUS = 'LOCAL READY' OR ( COLLECTION_STATUS = 'RATE NOT AVAILABLE' OR COLLECTION_STATUS = 'INVALID CURRENCY')
46: AND INSTANCE = (SELECT INSTANCE_CODE
47: FROM EDW_LOCAL_INSTANCE);
48: END;
49:
50: ------------------------------------------------------------
51: --PROCEDURE INSERT_MISSING_RATES_IN_TMP

Line 110: FROM edw_local_instance;

106:
107:
108: SELECT instance_code
109: INTO l_instance1
110: FROM edw_local_instance;
111:
112: SELECT instance_code
113: INTO l_instance2
114: FROM edw_local_instance@edw_apps_to_wh;

Line 114: FROM edw_local_instance@edw_apps_to_wh;

110: FROM edw_local_instance;
111:
112: SELECT instance_code
113: INTO l_instance2
114: FROM edw_local_instance@edw_apps_to_wh;
115:
116: IF (l_instance1 = l_instance2) THEN
117: RETURN TRUE;
118: END IF;

Line 143: FROM EDW_LOCAL_INSTANCE);

139: UPDATE FII_AP_SCH_PAYMTS_FSTG
140: SET COLLECTION_STATUS = 'READY'
141: WHERE COLLECTION_STATUS = 'LOCAL READY'
142: AND INSTANCE = (SELECT INSTANCE_CODE
143: FROM EDW_LOCAL_INSTANCE);
144:
145: RETURN(sql%rowcount);
146:
147: EXCEPTION