APPS.POA_EDW_CSTM_MSR_F_SIZE dependencies on POA_CM_EVALUATION

Line 14: poa_cm_evaluation pme,

10: -- dbms_output.enable(100000);
11:
12: select count(*) into p_num_rows
13: from
14: poa_cm_evaluation pme,
15: poa_cm_eval_scores pms
16: WHERE pme.evaluation_id = pms.evaluation_id
17: and greatest(pme.last_update_date, pms.last_update_date)
18: between p_from_date and p_to_date;

Line 66: from poa_cm_evaluation

62: avg(nvl(vsize(item_id), 0)),
63: avg(nvl(vsize(category_id), 0)),
64: avg(nvl(vsize(comments), 0)),
65: avg(nvl(vsize(evaluation_id), 0))
66: from poa_cm_evaluation
67: where last_update_date between
68: p_from_date and p_to_date;
69:
70: CURSOR c_2 IS