APPS.EDW_HR_ASSGNMNT_M_SIZING dependencies on PER_ASSIGNMENT_STATUS_TYPES
Line 123: FROM per_assignment_status_types
119:
120: CURSOR ast_cur IS
121: SELECT
122: avg(nvl(vsize(assignment_status_type_id),0)) 123: FROM per_assignment_status_types 124: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
125:
126: CURSOR pgr_cur IS
127: SELECT avg(nvl(vsize(people_group_id),0))