546: --
547:
548: CURSOR c_per_system_status IS
549: SELECT pas.per_system_status
550: FROM per_assignment_status_types pas
551: WHERE pas.assignment_status_type_id = p_assignment_status_type_id;
552:
553: l_ret_val per_assignment_status_types.per_system_status%type;
554: --
549: SELECT pas.per_system_status
550: FROM per_assignment_status_types pas
551: WHERE pas.assignment_status_type_id = p_assignment_status_type_id;
552:
553: l_ret_val per_assignment_status_types.per_system_status%type;
554: --
555: BEGIN
556: --
557: OPEN c_per_system_status;