APPS.HR_EDW_WRK_CMPSTN_F_SIZING dependencies on PER_ALL_ASSIGNMENTS_F

Line 83: FROM per_all_assignments_f asg

79: ,avg(nvl(vsize(asg.location_id ),0))
80: ,avg(nvl(vsize(asg.organization_id),0))
81: ,avg(nvl(vsize(asg.person_id ),0))
82: ,avg(nvl(vsize(asg.position_id ),0))
83: FROM per_all_assignments_f asg
84: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
85:
86: BEGIN
87: