APPS.FII_PA_BUDGET_F_C dependencies on EDW_LOCAL_INSTANCE

Line 72: FROM EDW_LOCAL_INSTANCE);

68: BEGIN
69: DELETE FII_PA_BUDGET_FSTG
70: WHERE COLLECTION_STATUS = 'LOCAL READY' OR ( COLLECTION_STATUS = 'RATE NOT AVAILABLE' OR COLLECTION_STATUS = 'INVALID CURRENCY')
71: AND INSTANCE = (SELECT INSTANCE_CODE
72: FROM EDW_LOCAL_INSTANCE);
73: END;
74:
75: ------------------------------------------------------------
76: --PROCEDURE INSERT_MISSING_RATES_IN_TMP

Line 133: FROM edw_local_instance;

129:
130:
131: SELECT instance_code
132: INTO l_instance1
133: FROM edw_local_instance;
134:
135: SELECT instance_code
136: INTO l_instance2
137: FROM edw_local_instance@edw_apps_to_wh;

Line 137: FROM edw_local_instance@edw_apps_to_wh;

133: FROM edw_local_instance;
134:
135: SELECT instance_code
136: INTO l_instance2
137: FROM edw_local_instance@edw_apps_to_wh;
138:
139: IF (l_instance1 = l_instance2) THEN
140: RETURN TRUE;
141: END IF;

Line 165: FROM EDW_LOCAL_INSTANCE);

161: UPDATE FII_PA_BUDGET_FSTG
162: SET COLLECTION_STATUS = 'READY'
163: WHERE COLLECTION_STATUS = 'LOCAL READY'
164: AND INSTANCE = (SELECT INSTANCE_CODE
165: FROM EDW_LOCAL_INSTANCE);
166:
167: RETURN(sql%rowcount);
168:
169: EXCEPTION