DBA Data[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: