APPS.OPI_EDW_JOB_DETAIL_FOPM_SZ dependencies on EDW_TIME_PKG

Line 157: SELECT avg(nvl(vsize(substr(edw_time_pkg.cal_day_fk

153: SELECT avg(nvl(vsize(ORGN_CODE), 0))
154: FROM SY_ORGN_MST;
155:
156: CURSOR TRX_DATE_PK is
157: SELECT avg(nvl(vsize(substr(edw_time_pkg.cal_day_fk
158: (BH.ACTUAL_CMPLT_DATE,SOB.SET_OF_BOOKS_ID),1,120)),0))
159: FROM
160: PM_BTCH_HDR BH,
161: SY_ORGN_MST OM,