APPS.PQH_SS_WORKFLOW dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 811: FROM per_assignment_status_types

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