DBA Data[Home] [Help]

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))