APPS.PSP_ENC_ASSIGNMENT_CHANGES dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 408: from per_assignment_status_types

404: THEN
405:
406: select count(*)
407: into l_count
408: from per_assignment_status_types
409: where p_new_asg_status_type_id = assignment_status_type_id
410: and per_system_status = 'TERM_ASSIGN';
411:
412: IF l_count = 1