APPS.GMS_AWARD_STATUS dependencies on GMS_PERSONNEL
Line 13: FROM gms_personnel
9: l_award_role VARCHAR2(30);
10:
11: CURSOR award_primary_member IS
12: SELECT personnel_id 13: FROM gms_personnel 14: WHERE award_id = x_award_id
15: AND award_role = l_award_role
16: ORDER BY end_date_active desc;
17: