APPS.OPI_EDW_OPI_ACTV_M_SZ dependencies on CST_ACTIVITIES

Line 10: CST_ACTIVITIES

6: p_num_rows OUT NOCOPY NUMBER) IS
7: CURSOR c_cnt_rows IS
8: select count(*) cnt
9: FROM
10: CST_ACTIVITIES
11: where last_update_date between p_from_date and p_to_date ;
12: BEGIN
13:
14: OPEN c_cnt_rows;

Line 59: CST_ACTIVITIES

55: avg(nvl(vsize(LAST_UPDATE_DATE), 0)),
56: -- CREATION_DATE
57: avg(nvl(vsize(CREATION_DATE), 0))
58: FROM
59: CST_ACTIVITIES
60: WHERE
61: last_update_date between p_from_date and p_to_date ;
62:
63: CURSOR c_2 IS