APPS.PQH_SS_WORKFLOW dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 808: FROM per_assignment_status_types

804: WHERE assignment_id = c_asgnId
805: AND effective_end_date <= trunc(c_effective_date)
806: AND assignment_status_type_id in (
807: SELECT assignment_status_type_id
808: FROM per_assignment_status_types
809: WHERE per_system_status in ('TERM_ASSIGN', 'END'));
810: --
811: -- Check if assignment is terminated in future
812: CURSOR cur_fut_term_asg (c_asgnId NUMBER, c_effective_date DATE) IS