APPS.FII_PA_REVENUE_F_C dependencies on EDW_LOCAL_INSTANCE

Line 79: FROM EDW_LOCAL_INSTANCE);

75: BEGIN
76: DELETE FII_PA_REVENUE_FSTG
77: WHERE COLLECTION_STATUS = 'LOCAL READY' OR ( COLLECTION_STATUS = 'RATE NOT AVAILABLE' OR COLLECTION_STATUS = 'INVALID CURRENCY')
78: AND INSTANCE = (SELECT INSTANCE_CODE
79: FROM EDW_LOCAL_INSTANCE);
80: END;
81:
82: ------------------------------------------------------------
83: --PROCEDURE INSERT_MISSING_RATES_IN_TMP

Line 163: FROM edw_local_instance;

159:
160:
161: SELECT instance_code
162: INTO l_instance1
163: FROM edw_local_instance;
164:
165: SELECT instance_code
166: INTO l_instance2
167: FROM edw_local_instance@edw_apps_to_wh;

Line 167: FROM edw_local_instance@edw_apps_to_wh;

163: FROM edw_local_instance;
164:
165: SELECT instance_code
166: INTO l_instance2
167: FROM edw_local_instance@edw_apps_to_wh;
168:
169: IF (l_instance1 = l_instance2) THEN
170: RETURN TRUE;
171: END IF;

Line 196: FROM EDW_LOCAL_INSTANCE);

192: UPDATE FII_PA_REVENUE_FSTG
193: SET COLLECTION_STATUS = 'READY'
194: WHERE COLLECTION_STATUS = 'LOCAL READY'
195: AND INSTANCE = (SELECT INSTANCE_CODE
196: FROM EDW_LOCAL_INSTANCE);
197:
198: RETURN(sql%rowcount);
199:
200: EXCEPTION