103: ,assg.supervisor_id supervisor_id
104: FROM
105: per_all_assignments_f assg
106: ,per_assignment_status_types ast
107: ,per_people_x sup
108: ,per_people_x sub
109: WHERE assg.person_id = p_psn_id
110: AND p_date BETWEEN assg.effective_start_date
111: AND assg.effective_end_date
104: FROM
105: per_all_assignments_f assg
106: ,per_assignment_status_types ast
107: ,per_people_x sup
108: ,per_people_x sub
109: WHERE assg.person_id = p_psn_id
110: AND p_date BETWEEN assg.effective_start_date
111: AND assg.effective_end_date
112: AND assg.assignment_status_type_id = ast.assignment_status_type_id