94: -----------------------------------------------------
95:
96: select gp.person_id
97: into l_award_manager_id
98: from gms_personnel gp,
99: per_assignments_f pa,
100: per_assignment_status_types past
101: where gp.award_id = p_award_id
102: and gp.award_role = C_AWARD_MANAGER_ROLE
100: per_assignment_status_types past
101: where gp.award_id = p_award_id
102: and gp.award_role = C_AWARD_MANAGER_ROLE
103: AND gp.start_date_active = ( select max(gp2.start_date_active)
104: from gms_personnel gp2
105: where gp2.award_role = C_AWARD_MANAGER_ROLE
106: and gp2.award_id = p_award_id
107: and gp2.start_date_active <= trunc(sysdate)
108: )