APPS.HR_ASSIGNMENT_COMMON_SAVE_WEB dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 175: from per_assignment_status_types

171: and l_effective_date between effective_start_date and effective_end_date;
172: --
173: cursor status_type is
174: select per_system_status
175: from per_assignment_status_types
176: where assignment_status_type_id=p_assignment_status_type_id;
177: --
178: begin
179: --