APPS.GMD_QC_STATUS_NEXT_PVT SQL Statements

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

Line: 18

      SELECT rework_status
      FROM GMD_QC_STATUS_NEXT
      WHERE current_status = p_from_status
      AND target_status  = p_to_status
	  AND entity_type  = p_entity_type
	  AND pending_status IS NOT NULL;

Line: 41

      SELECT pending_status
      FROM GMD_QC_STATUS_NEXT
      WHERE current_status = p_from_status
      AND target_status  = p_to_status
	  AND  entity_type = p_entity_type;