APPS.EDW_HR_PERSON_M_SIZING dependencies on HR_ALL_ORGANIZATION_UNITS

Line 20: ,hr_all_organization_units bgr

16: FROM (
17: SELECT COUNT(*) total
18: FROM ( SELECT DISTINCT peo.person_id
19: FROM per_all_people_f peo
20: ,hr_all_organization_units bgr
21: WHERE peo.business_group_id = bgr.organization_id
22: AND greatest( NVL(peo.last_update_date,to_date('01-01-2000','DD-MM-YYYY')),
23: NVL(bgr.last_update_date,to_date('01-01-2000','DD-MM-YYYY')))
24: BETWEEN p_from_date AND p_to_date )

Line 28: ,hr_all_organization_units org

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')))
32: BETWEEN p_from_date AND p_to_date

Line 36: ,hr_all_organization_units org

32: BETWEEN p_from_date AND p_to_date
33: UNION ALL
34: SELECT COUNT(*)
35: FROM mtl_planners mp
36: ,hr_all_organization_units org
37: WHERE mp.organization_id = org.organization_id
38: AND greatest( NVL(mp.last_update_date, to_date('01-01-2000','DD-MM-YYYY')),
39: NVL(org.last_update_date,to_date('01-01-2000','DD-MM-YYYY')))
40: BETWEEN p_from_date AND p_to_date

Line 140: FROM hr_all_organization_units

136:
137: /* Length of an organization name */
138: CURSOR bgr_cur IS
139: SELECT avg(nvl(vsize(name),0))
140: FROM hr_all_organization_units
141: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
142:
143: /* Length of person attributes - plus a count (weight) of size of table */
144: CURSOR peo_cur IS