APPS.OPI_EDW_COGS_F_SZ dependencies on EDW_TIME_PKG
Line 189: SELECT AVG(Nvl(Vsize(EDW_TIME_PKG.CAL_DAY_FK(Sysdate, set_of_books_id) ),0))
185: FROM bom_department_resources
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))