APPS.OPI_EDW_COGS_F_SZ dependencies on AMS_CAMPAIGNS_ALL_B

Line 204: FROM ams_campaigns_all_b

200: WHERE last_update_date between p_from_date and p_to_date;
201:
202: CURSOR c_campaign IS
203: SELECT AVG(Nvl(Vsize(user_status_id), 0))
204: FROM ams_campaigns_all_b
205: WHERE last_update_date between p_from_date and p_to_date;
206:
207: x_trx_date_fk NUMBER;
208: x_instance_fk NUMBER;