APPS.EDW_HR_PERSON_M_SIZING dependencies on MTL_PLANNERS

Line 35: FROM mtl_planners mp

31: NVL(org.last_update_date,to_date('01-01-2000','DD-MM-YYYY')))
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')))

Line 212: FROM mtl_planners

208: avg(nvl(vsize(planner_code),0))
209: ,avg(nvl(vsize(description),0))
210: ,avg(nvl(vsize(organization_id),0))
211: ,count(planner_code)
212: FROM mtl_planners
213: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
214:
215:
216: BEGIN