APPS.FII_AP_INV_PAYMTS_F_C dependencies on EDW_LOCAL_INSTANCE

Line 45: FROM EDW_LOCAL_INSTANCE);

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

Line 102: FROM edw_local_instance;

98:
99:
100: SELECT instance_code
101: INTO l_instance1
102: FROM edw_local_instance;
103:
104: SELECT instance_code
105: INTO l_instance2
106: FROM edw_local_instance@edw_apps_to_wh;

Line 106: FROM edw_local_instance@edw_apps_to_wh;

102: FROM edw_local_instance;
103:
104: SELECT instance_code
105: INTO l_instance2
106: FROM edw_local_instance@edw_apps_to_wh;
107:
108: IF (l_instance1 = l_instance2) THEN
109: RETURN TRUE;
110: END IF;

Line 135: FROM EDW_LOCAL_INSTANCE);

131: UPDATE FII_AP_INV_PAYMTS_FSTG
132: SET COLLECTION_STATUS = 'READY'
133: WHERE COLLECTION_STATUS = 'LOCAL READY'
134: AND INSTANCE = (SELECT INSTANCE_CODE
135: FROM EDW_LOCAL_INSTANCE);
136:
137: RETURN(sql%rowcount);
138:
139: EXCEPTION