DBA Data[Home] [Help]

APPS.OPI_EDW_COGS_F_SZ dependencies on GL_SETS_OF_BOOKS

Line 190: FROM gl_sets_of_books;

186: WHERE last_update_date between p_from_date and p_to_date;
187:
188: CURSOR c_trx_date_fk IS
189: SELECT AVG(Nvl(Vsize(EDW_TIME_PKG.CAL_DAY_FK(Sysdate, set_of_books_id) ),0))
190: FROM gl_sets_of_books;
191:
192: CURSOR c_offer IS
193: SELECT AVG(Nvl(Vsize(activity_offer_id), 0))
194: FROM ams_act_offers