APPS.FII_PA_COST_F_C dependencies on EDW_LOCAL_INSTANCE

Line 74: FROM EDW_LOCAL_INSTANCE);

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

Line 135: FROM edw_local_instance;

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

Line 139: FROM edw_local_instance@edw_apps_to_wh;

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

Line 168: FROM EDW_LOCAL_INSTANCE);

164: UPDATE FII_PA_COST_FSTG
165: SET COLLECTION_STATUS = 'READY'
166: WHERE COLLECTION_STATUS = 'LOCAL READY'
167: AND INSTANCE = (SELECT INSTANCE_CODE
168: FROM EDW_LOCAL_INSTANCE);
169:
170: RETURN(sql%rowcount);
171:
172: EXCEPTION