[Home] [Help]
APPS.OPI_EDW_COGS_FOPM_SZ dependencies on EDW_TIME_PKG
Line 72: SELECT AVG(Nvl(Vsize(EDW_TIME_PKG.CAL_DAY_FK(Sysdate, SOB_ID) ),0)) date_fk,
68: avg(nvl(vsize(instance_code), 0))
69: FROM EDW_LOCAL_INSTANCE ;
70:
71: CURSOR c_other_dtl IS
72: SELECT AVG(Nvl(Vsize(EDW_TIME_PKG.CAL_DAY_FK(Sysdate, SOB_ID) ),0)) date_fk,
73: AVG(NVL(VSIZE(SOB_ID),0)) SOB_ID,
74: AVG(NVL(VSIZE(ORG_ID),0)) ORG_ID
75: FROM gl_plcy_mst;
76: