APPS.GMS_AWARD_STATUS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 12

         SELECT personnel_id
           FROM gms_personnel
          WHERE award_id = x_award_id
            AND award_role = l_award_role
          ORDER BY end_date_active desc;

Line: 27

	   SELECT  award_id
    	   INTO  l_award_id
           FROM  gms_awards
           WHERE  award_id = x_award_id;