APPS.EDW_HR_PERSON_M_SIZING dependencies on RA_SALESREPS_ALL

Line 27: FROM ra_salesreps_all rs

23: NVL(bgr.last_update_date,to_date('01-01-2000','DD-MM-YYYY')))
24: BETWEEN p_from_date AND p_to_date )
25: UNION ALL
26: SELECT COUNT(*) total
27: FROM ra_salesreps_all rs
28: ,hr_all_organization_units org
29: WHERE rs.org_id = org.organization_id (+)
30: AND greatest( NVL( rs.last_update_date,to_date('01-01-2000','DD-MM-YYYY')),
31: NVL(org.last_update_date,to_date('01-01-2000','DD-MM-YYYY')))

Line 198: FROM ra_salesreps_all

194: ,avg(nvl(vsize(salesrep_number),0))
195: ,avg(nvl(vsize(name),0))
196: ,avg(nvl(vsize(org_id),0))
197: ,count(salesrep_id)
198: FROM ra_salesreps_all
199: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
200:
201: /**************/
202: /* MTL Source */